Answer Posted / sunil kumar singh
Surrogate Key is artificial that is created for
datawarehousing for generating the unique number for each
record. Surrogate key works on the behalf of primary key.
And main purpose of surrogate key is to maintain the
historical record.
Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
How do you load first and last records into target table?
What are the different lookup cache(s)?
What does command task mean?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the use of source qualifier?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Enlist the various types of transformations.
What is informatica etl tool?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain what is informatica metadata and where is it stored?
What are the new features of Power Center 5.0?
What are the guidelines to be followed while using union transformation?
Separate from an archive server and a powerhouse?
Where are the source flat files kept before running the session?