How can i maintain unique surrogate key if 2 seperate
workflows from different repository run and insert/update the
main table at the same time.
Answer Posted / nithya
By having a dynamic lookup at the target table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
tell me the rules and responsblites in our project(my project is development)
Define sessions in informatica etl?
What are the various types of transformation?
What is fact table? Explain the different kinds of facts.
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 is song in infrmatica...?
How to do unit testing in informatica? How to load data in informatica ?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is update strategy transform?
What is resilience time?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is rank transform?
Explain the use of aggregator cache file?
What is meant by lookup transformation? Explain the types of lookup transformation?