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.
- 9 Answers
- 13252 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / jatin marwaha
Use Dynamic Lookup on target table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
What is the difference between a repository server and a powerhouse?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to create or import flat file definition in to the warehouse designer?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
State the limitations where we cannot use joiner in the mapping pipeline?
Differentiate between a repository server and a powerhouse?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a mapplet/worklet in informatica?
Explain the features of connected and unconnected lookup.
Performance tuning in UNIX for informatica mappings?
How to load a Dimension ? and how to load a fact table?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What does command task mean?
Please let me know how to make Data masking in informatica..
