Answer Posted / latha
actually it appears in picture when a critical
column(example location) occurs in a table.In order to avoid
the critical column we are using surrogate key.surrogate key
is also a primary key.
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What are the features of complex mapping?
What is sq transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the use of target designer?
What does refresh system mean, and what are its distinctive choice?
What is a difference between complete, stop and abort?
what is the -ve test case in your project.
can we override a native sql query within informatica? Where do we do it?
What all join we can perform in LOOKUP transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
generate date / time dimension in informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain the pipeline partition with real time example?
What is joiner change?
Explain the different lookup methods used in informatica?