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
What is the fact table?
What are the components of workflow manager?
How to load the data from people soft hrm to people soft erm using informatica?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the new features of informatica 9.x in developer level?
Enlist some properties of sessions.
What is the benefit of partitioning a session?
Enterprise data warehouse your projects phase by phase explain?
How might you approve all mappings in the archive all the while?
What is a router transformation?
What is the need for an etl tool?
How to create a non-reusable instance of reusable transformations?
How an expression transformation differs from aggregator transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is blocking transformation?