Interested to Buy Any Domain ? << Click Here >> for more details...
surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 15541 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 |
How big was your fact table
What is the main difference between a Joiner Transformation and Union Transformation?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
What is a standalone command task?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
How do you set a varible in incremental aggregation
What is the surrogate key?
What is the functionality of update strategy?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
without using emailtask how will send a mail from informatica?
without table how to come first record only in oracle?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
Teradata 
