surrogate keys usage in Oracle and Informatica?
Answer Posted / tanmoy
A surrogate key is the substitution of natural primary key
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Difference between Target-based loading and constraint-based loading?
What is Index Caches size?
How can we use mapping variables in informatica?
How would you join a node to the already existing domain?
How to extract sap data using informatica? What is abap? What are idocs?
What are the advantages of informatica?
Enterprise data warehouse your projects phase by phase explain?
Differences between version 7.x and 8.x.
Define filter transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain sessions. Explain how batches are used to combine executions?
Briefly define reusable transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How many types of sessions are there in informatica.please explain them?