Sunday, 1 February 2015

tcs informatica interview questions and answers (Part10)

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
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5  Part6  Part7  Part8  Part9  Part10

No comments:

Post a comment