what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?

Answer Posted / soujanya

surrogate key is the system generated key to avoid primary
key conatraint.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the settings that you use to configure the joiner transformation?

622


During the running session, output files are created by informatica server. Enlist few of them.

548


What are ETL Tools?

675


explain about unit testing? in real time?

1678


Reusable transformation and shortcut differences

1388






Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2290


Enlist the tasks for which source qualifier transformation is used.

598


tell me about your project functionality

1877


Enlist some properties of sessions.

638


Which transformation should we use to normalise the COBOL and relational sources?

753


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1679


What are the different clients of powercenter?

609


Why filter transformation is an active one?

572


What is a joiner transformation and why it is an active one?

584


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1654