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
- 12564 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
Hi Sameer.
Thanks for the reply.
Can we use same sequence generator across different repositories?
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Briefly describe lookup transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Enlist the tasks for which source qualifier transformation is used.
Did u used latest transformations of 8.6.0? for what?
Have you worked with/created Parameter file
How can you validate all mappings in the repository simultaneously?
Explain lookup transformation in informatica
what is degenerated dimension?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to extract sap data using informatica? What is abap? What are idocs?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
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
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a grid in Informatica?
What do you mean incremental aggregation?
