surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 14626 Views
- ITC Infotech, Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / avinash kumar
If u have mulitiple records then for mentain this records we
need to generate surrogate key in informatica
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / mahendra reddy ongole
surrogate key is system generated sequence numbers which
are used for maintaining the history in SCD-TYPE-2
applications
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / tanmoy
A surrogate key is the substitution of natural primary key
| Is This Answer Correct ? | 3 Yes | 3 No |
What is depict expression change?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
can any one explain me about junk dimension
expain about the tune parameters?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
Where do you create/define mapping parameter and mapping variable?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
What is rank index in rank transformation?
Why update strategy and union transformations are active? Explain with examples.
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
Teradata 
