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
Is there any way to read the ms excel datas directly into informatica?
What is an expression transformation?
How to update or delete the rows in a target, which do not have key fields?
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 Power Center 5.0?
What is a sorter transformation?
What are session parameters ? How do you set them?
What is domain and gateway node?
What are the different lookup cache(s)?
What is joiner transformation in informatica?
What you know about transaction control transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the types of caches in lookup?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is data movement mode in Informatica and difference between them?