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
- 13250 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / deepak
Create a sequence generator transformation in transformation developer and use this transformation instead of using separate sequence generators. 2. Use mapplet and design
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
What do you mean incremental aggregation?
What is mapping debugger?
On which transformations you created partitions in your project?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain informatica architecture - version 8 / 9
What is domain and gateway node?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the maplet?
Different sorts of metadata that stores in the storage facility?
Define the various join types of joiner transformation?
What is rank index in rank transformation?
what is index?how it can work in informatica
