what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
Answer Posted / raghureddy
It has system generated artificial primary key values .
which allows to maintian historical data in dwh
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What does update strategy mean, and what are the different option of it?
What do you mean by channel change?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the use of code page?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a connected transformation?
What are the designer tools for creating transformations?
Name the different lookup cache(s)?
What is a standalone command task?
Briefly describe lookup transformation?
Define enterprise data warehousing?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain in detail scd type 2 through mapping.
Explain pmcmd command usage in informatica