91. HOW CAN YOU SAY THAT UNION TRANSFORMATION IS ACTIVE TRANSFORMATION?
By Definition, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different
92. WHAT IS THE DIFFERENCE BETWEEN POWERCENTER 6 AND POWERCENTER 7?
1)lookup the flat files in informatica 7.X but we cann't lookup flat files in informatica 6.X 2) External Stored Procedure Transformation is not available in informatica 7.X but this transformation
93. WHAT ARE LOAD TYPES IN INFORMATICA AND WHAT IS DELTA LOAD
There are two types of load bulk and normal.we ll use normal type almost, bulk is used in for the data which is huge to insert to the target
94. HOW CAN I TRANSFORM ROW TO COLUMN?
Through Normalizer Transformation we can do this.
95. 1. CAN U EXPLAIN ONE CRITICAL MAPPING? 2. PERFORMANCE ISSUE WHICH ONE IS BETTER? WHETHER CONNECTED LOOKUP TRANSFORMATION OR UNCONNECTED ONE?
it depends on your data and the type of operation u r doing. If u need to calculate a value for all the rows or for the maximum rows coming out of the source then go for a connected lookup. Or,i
96. DIFFERENCE BETWEEN STATIC CACHE AND DYNAMIC CACHE
Static cache Dynamic cache U can not insert or update the cache U can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache w
97. WHAT IS TRANSACTION?
Transaction is a logical unit of work that comprises one or more sql statements executed by a single user
98. WHAT IS THE DIFFERENCE BETWEEN NORMAL LOAD AND BULK LOAD?
Normal Load: Normal load will write information to the database log file so that if any recorvery is needed it is will be helpful. when the source file is a text file and loading data to a table,in su
99. WHY SORTER TRANSFORMATION IS AN ACTIVE TRANSFORMATION?
This is type of active transformation which is responsible for sorting the data either in the ascending order or descending order according to the key specifier. the port on which the sorting takes pl
100. WHAT IS THE LOGIC WILL YOU IMPLEMENT TO LOAD THE DATA IN TO ONE FACTV FROM 'N' NUMBER OF DIMENSION TABLES.
Normally every one use 1) slowly changing dimensions 2) slowly growing dimensions
By Definition, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different
92. WHAT IS THE DIFFERENCE BETWEEN POWERCENTER 6 AND POWERCENTER 7?
1)lookup the flat files in informatica 7.X but we cann't lookup flat files in informatica 6.X 2) External Stored Procedure Transformation is not available in informatica 7.X but this transformation
93. WHAT ARE LOAD TYPES IN INFORMATICA AND WHAT IS DELTA LOAD
There are two types of load bulk and normal.we ll use normal type almost, bulk is used in for the data which is huge to insert to the target
94. HOW CAN I TRANSFORM ROW TO COLUMN?
Through Normalizer Transformation we can do this.
95. 1. CAN U EXPLAIN ONE CRITICAL MAPPING? 2. PERFORMANCE ISSUE WHICH ONE IS BETTER? WHETHER CONNECTED LOOKUP TRANSFORMATION OR UNCONNECTED ONE?
it depends on your data and the type of operation u r doing. If u need to calculate a value for all the rows or for the maximum rows coming out of the source then go for a connected lookup. Or,i
96. DIFFERENCE BETWEEN STATIC CACHE AND DYNAMIC CACHE
Static cache Dynamic cache U can not insert or update the cache U can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache w
97. WHAT IS TRANSACTION?
Transaction is a logical unit of work that comprises one or more sql statements executed by a single user
98. WHAT IS THE DIFFERENCE BETWEEN NORMAL LOAD AND BULK LOAD?
Normal Load: Normal load will write information to the database log file so that if any recorvery is needed it is will be helpful. when the source file is a text file and loading data to a table,in su
99. WHY SORTER TRANSFORMATION IS AN ACTIVE TRANSFORMATION?
This is type of active transformation which is responsible for sorting the data either in the ascending order or descending order according to the key specifier. the port on which the sorting takes pl
100. WHAT IS THE LOGIC WILL YOU IMPLEMENT TO LOAD THE DATA IN TO ONE FACTV FROM 'N' NUMBER OF DIMENSION TABLES.
Normally every one use 1) slowly changing dimensions 2) slowly growing dimensions
More Questions & Answers :-
No comments:
Post a Comment