Answer Posted / lavanya
A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Differentiate between reusable transformation and mapplet.
What are mapplets? How is it different from a Reusable Transformation?
Explain sessions?
Explain the pipeline partition with real time example?
Which transformation should we use to normalise the COBOL and relational sources?
What is the need of an ETL tool?
Under which circumstances, informatica server creates reject files?
What are the types of lookup transformation?
How do you load unique records into one target table and duplicate records into a different target table?
What is target designer and target load order?
what is the size of u r source(like file or table)?
Which transformation is needed while using the Cobol sources as source definitions?
Can u generate reports in Informatica?
expain about the tune parameters?
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?