Interested to Buy Any Domain ? << Click Here >> for more details...
surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 15932 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 |
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
How to join three sources using joiner? Explain though mapping flow.
What is a connected transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
How do you remove duplicate records in informatica?
What is the difference between a table and the materialized view?
How can we integrate different flat file data in a single mapping and with in a single execution
what happens if you try to create a shortcut to a non- shared folder?
how you will maintain version?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Teradata 
