why we are using surogate key in real time give me
explanation
Answer Posted / nagendra phani
SUROGATE KEY is used to generate a primary key. and it is
system generated number
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
What is an Integration service in Informatica?
What is source qualifier transformation in informatica?
What is a joiner transformation?
can we override a native sql query within informatica? How do we do it?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is a shortcut and copy in Informatica and how two are different with each other?
As union transformation gives UNION ALL output, how you will get the UNION output?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What differs when we choose the sorted input for aggregator transformation?
what is the difference between informatica6.1 and infomatica7.1
Can we get 1st record through Informatica(without sequence number).
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is target load order?