Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15671 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / suneel reddy
Create triggers in the DataBase on Inserts, use Oracle sequence to generate/fill the surrogate key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
update strategy transformation in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Do you find any difficulty while working with flat files as source and target?
what is the hint? how to use it to reduce the query processing in program?
What is rank transformation?
Explain joiner transformation in informatica
What are the designer tools for creating transformations?
What is the different lookup cache(s)?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What does reusable transformation mean?
How to implement security measures using repository manager?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain the aggregator transformation?
