Interested to Buy Any Domain ? << Click Here >> for more details...
surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 15589 Views
- ITC Infotech, Oracle, I also Faced
- E-Mail Answers
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
Mention some types of transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain the informatica workflow?
What are the static cache and dynamic cache in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain what are the different versions of informatica?
Differentiate between router and filter transformation?
What is the way to execute pl/sql script using informatica mapping?
What are the types of schemas we have in data warehouse.
Why sorter is an active transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How can you differentiate between powercenter and power map?
What is the command used to run a batch?
Is there any way to read the ms excel datas directly into informatica?
Explain what is informatica metadata and where is it stored?
