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 / jatin marwaha
Use Dynamic Lookup on target table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Did u used latest transformations of 8.6.0? for what?
Explain lookup transformation in informatica
What is the fact table?
How we can use union transformation?
What is a grid in Informatica?
How do you load first and last records into target table?
What are connected or unconnected transformations?
How many number of sessions can one group in batches?
Define mapping and session?
What is a difference between complete, stop and abort?
Slowly changing dimensions, types and where will you use them
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Can we get 1st record through Informatica(without sequence number).