11. HOW THE INFORMATICA SERVER SORTS THE STRING VALUES IN RANK TRANSFORMATION?
When Informatica Server runs in UNICODE data movement mode ,then it uses the sort order configured in session properties.
12. EXPLAIN ABOUT INFORMATICA SERVER ARCHITECTURE?
Informatica server,load manager/rs,data transfer manager,reader,temp server and writer are the components of informatica server. first load manager sends a request to the reader if the reader is ready
13. HOW CAN YOU CREATE OR IMPORT FLAT FILE DEFINITION IN TO THE WAREHOUSE DESIGNER?
You can not create or import flat file defintion in to warehouse designer directly.Instead you must analyze the file in source analyzer,then drag it into the warehouse designer. When you drag the fl
14. HOW CAN YOU IMPROVE SESSION PERFORMANCE IN AGGREGATOR TRANSFORMATION?
One way is supplying the sorted input to aggregator transformation. In situations where sorted input cannot be supplied, we need to configure data cache and index cache at session/transformation level
15. WHAT IS THE DIFFERENCE BETWEEN STOP AND ABORT?
stop: _______If the session u want to stop is a part of batch you must stop the batch, if the batch is part of nested batch, Stop the outer most batch Abort:---- You can issue the abort comma
16. IN UPDATE STRATEGY TARGET TABLE OR FLAT FILE WHICH GIVES MORE PERFORMANCE? WHY?
Pros: Loading, Sorting, Merging operations will be faster as there is no index concept and Data will be in ASCII mode. Cons: There is no concept of updating existing records in flat file. As the
17. HOW MANY TYPES OF DIMENSIONS ARE AVAILABLE IN INFORMATICA?
There r 3 types of dimensions 1.star schema 2.snowflake schema 3.glaxy schema
18. WHAT IS DIFFERENCE B/W INFORMATICA 7.1 AND ABINITIO
There is a lot of diffrence between informatica an Ab Initio In Ab Initio we r using 3 parllalisim but Informatica using 1 parllalisim In Ab Initio no scheduling option we can scheduled manual
19. WHEN WE CREATE A TARGET AS FLAT FILE AND SOURCE AS ORACLE. HOW CAN I SPECIFY FIRST ROWS AS COLUMN NAMES IN FLAT FILES.
Use a pre sql statement....but this is a hardcoding method...if you change the column names or put in extra columns in the flat file, you will have to change the insert statement
20. WHAT IS THE DIFFERENCE BETWEEN FILTER AND LOOKUP TRANSFORMATION?
1) Filter transformation is an Active transformation and Lookup is a Passive transformation 2) Filter transformation is used to Filter rows based on condition and Lookup is used to to look up data
When Informatica Server runs in UNICODE data movement mode ,then it uses the sort order configured in session properties.
12. EXPLAIN ABOUT INFORMATICA SERVER ARCHITECTURE?
Informatica server,load manager/rs,data transfer manager,reader,temp server and writer are the components of informatica server. first load manager sends a request to the reader if the reader is ready
13. HOW CAN YOU CREATE OR IMPORT FLAT FILE DEFINITION IN TO THE WAREHOUSE DESIGNER?
You can not create or import flat file defintion in to warehouse designer directly.Instead you must analyze the file in source analyzer,then drag it into the warehouse designer. When you drag the fl
14. HOW CAN YOU IMPROVE SESSION PERFORMANCE IN AGGREGATOR TRANSFORMATION?
One way is supplying the sorted input to aggregator transformation. In situations where sorted input cannot be supplied, we need to configure data cache and index cache at session/transformation level
15. WHAT IS THE DIFFERENCE BETWEEN STOP AND ABORT?
stop: _______If the session u want to stop is a part of batch you must stop the batch, if the batch is part of nested batch, Stop the outer most batch Abort:---- You can issue the abort comma
16. IN UPDATE STRATEGY TARGET TABLE OR FLAT FILE WHICH GIVES MORE PERFORMANCE? WHY?
Pros: Loading, Sorting, Merging operations will be faster as there is no index concept and Data will be in ASCII mode. Cons: There is no concept of updating existing records in flat file. As the
17. HOW MANY TYPES OF DIMENSIONS ARE AVAILABLE IN INFORMATICA?
There r 3 types of dimensions 1.star schema 2.snowflake schema 3.glaxy schema
18. WHAT IS DIFFERENCE B/W INFORMATICA 7.1 AND ABINITIO
There is a lot of diffrence between informatica an Ab Initio In Ab Initio we r using 3 parllalisim but Informatica using 1 parllalisim In Ab Initio no scheduling option we can scheduled manual
19. WHEN WE CREATE A TARGET AS FLAT FILE AND SOURCE AS ORACLE. HOW CAN I SPECIFY FIRST ROWS AS COLUMN NAMES IN FLAT FILES.
Use a pre sql statement....but this is a hardcoding method...if you change the column names or put in extra columns in the flat file, you will have to change the insert statement
20. WHAT IS THE DIFFERENCE BETWEEN FILTER AND LOOKUP TRANSFORMATION?
1) Filter transformation is an Active transformation and Lookup is a Passive transformation 2) Filter transformation is used to Filter rows based on condition and Lookup is used to to look up data
No comments:
Post a Comment