Answer Posted / sai suresh
surrogate key is an artificial key , it will generate
automatinclly in sequence it will act as a primary key when
the data is heighly denormalized.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which version configuration tool used in ur project?
Mention few advantages of router transformation over filter transformation.
How to generate sequence numbers without using the sequence generator transformation?
Write the prerequisite tasks to achieve the session partition?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain the informatica workflow?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
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
Can you use flat files in Mapplets.
What are the designer tools for creating transformations?
Informatica Checkpoints
What is the use of transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
can you please explain me pre session and post session options?
How can repository reports be accessed without sql or other transformations?