why we are using surogate key in real time give me
explanation
Answer Posted / davan
Mainly we r using...the maintain the historical data.and we
can get the data diffrent sources so we can idetified the
every record.
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to generate sequence numbers using expression transformation?
How can a transformation be made reusable?
In development project what is the process to follow for an etl developer from day1
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is a joiner transformation and why it is an active one?
What is a code page?
What is a predefined event?
How can we create index after completion of load process?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How do you load only null records into target? Explain through mapping flow.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Differentiate between a database and data warehouse?
What is Index Caches size?
What is session task and command task?