31. CAN ANYONE EXPLAIN ERROR HANDLING IN INFORMATICA WITH EXAMPLES SO THAT IT WILL BE EASY TO EXPLAIN THE SAME IN THE INTERVIEW?
Go to the session log file there we will find the information regarding to the session initiation process, errors encountered. load summary. so by seeing the errors encountered during the
32. WHAT IS DIFFERENCE BETWEEN IIF AND DECODE FUNCTION
You can use nested IIF statements to test multiple conditions. The following example tests for various conditions and returns 0 if sales is zero or negative: IIF( SALES > 0, IIF( SALES < 50, SALAR
33. DIFFERENCE BETWEEN RANK AND DENSE RANK?
Rank: 1 2<--2nd position 2<--3rd position 4 5 Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.
34. WHAT IS MEANT BY AGGREGATE FACT TABLE AND WHERE IS IT USED?
Basically fact tables are two kinds 1. Aggregated factable and Factless fact table. Agregated factable has aggregarted columns. for eg. Total-Sal, Dep-Sal. where as in factless factable will not have
35. WHAT IS THE DIFFERENCE BETWEEN CONSTRAIND BASE LOAD ORDERING AND TARGET LOAD PLAN
Constraint based load ordering example: Table 1---Master Table 2---Detail If the data in table1 is dependent on the data in table2 then table2 should be loaded first.In such cases to con
36. WHAT IS THE DIFFERENCE BETWEEN CONNECTED AND UNCONNECTED STORED PROCEDURES?
Unconnected: The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another
37. WHAT ARE MAIN ADVANTAGES AND PURPOSE OF USING NORMALIZER TRANSFORMATION IN INFORMATICA?
Narmalizer Transformation is used mainly with COBOL sources where most of the time data is stored in de-normalized format. Also, Normalizer transformation can be used to create multiple rows from a si
38. HOW CAN WE PARTITION A SESSION IN INFORMATICA?
The Informatica PowerCenter Partitioning option optimizes parallel processing on multiprocessor hardware by providing a thread-based architecture and built-in data partitioning. GUI-based tools redu
39. WHAT IS UPDATE STRATEGY TRANSFORMATION?
The model you choose constitutes your update strategy, how to handle changes to existing rows. In PowerCenter and PowerMart, you set your update strategy at two different levels: Within a session.
40. WHEN DO U WE USE DYNAMIC CACHE AND WHEN DO WE USE STATIC CACHE IN AN CONNECTED AND UNCONNECTED LOOKUP TRANSFORMATION
We use dynamic cache only for connected lookup. We use dynamic cache to check whether the record already exists in the target table are not. And depending on that, we insert,update or delete the record.
Go to the session log file there we will find the information regarding to the session initiation process, errors encountered. load summary. so by seeing the errors encountered during the
32. WHAT IS DIFFERENCE BETWEEN IIF AND DECODE FUNCTION
You can use nested IIF statements to test multiple conditions. The following example tests for various conditions and returns 0 if sales is zero or negative: IIF( SALES > 0, IIF( SALES < 50, SALAR
33. DIFFERENCE BETWEEN RANK AND DENSE RANK?
Rank: 1 2<--2nd position 2<--3rd position 4 5 Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.
34. WHAT IS MEANT BY AGGREGATE FACT TABLE AND WHERE IS IT USED?
Basically fact tables are two kinds 1. Aggregated factable and Factless fact table. Agregated factable has aggregarted columns. for eg. Total-Sal, Dep-Sal. where as in factless factable will not have
35. WHAT IS THE DIFFERENCE BETWEEN CONSTRAIND BASE LOAD ORDERING AND TARGET LOAD PLAN
Constraint based load ordering example: Table 1---Master Table 2---Detail If the data in table1 is dependent on the data in table2 then table2 should be loaded first.In such cases to con
36. WHAT IS THE DIFFERENCE BETWEEN CONNECTED AND UNCONNECTED STORED PROCEDURES?
Unconnected: The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another
37. WHAT ARE MAIN ADVANTAGES AND PURPOSE OF USING NORMALIZER TRANSFORMATION IN INFORMATICA?
Narmalizer Transformation is used mainly with COBOL sources where most of the time data is stored in de-normalized format. Also, Normalizer transformation can be used to create multiple rows from a si
38. HOW CAN WE PARTITION A SESSION IN INFORMATICA?
The Informatica PowerCenter Partitioning option optimizes parallel processing on multiprocessor hardware by providing a thread-based architecture and built-in data partitioning. GUI-based tools redu
39. WHAT IS UPDATE STRATEGY TRANSFORMATION?
The model you choose constitutes your update strategy, how to handle changes to existing rows. In PowerCenter and PowerMart, you set your update strategy at two different levels: Within a session.
40. WHEN DO U WE USE DYNAMIC CACHE AND WHEN DO WE USE STATIC CACHE IN AN CONNECTED AND UNCONNECTED LOOKUP TRANSFORMATION
We use dynamic cache only for connected lookup. We use dynamic cache to check whether the record already exists in the target table are not. And depending on that, we insert,update or delete the record.
No comments:
Post a Comment