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
- 13255 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
What are mapplets? How is it different from a Reusable Transformation?
Sequence generator, when you move from develoment to production how will you reset
Where is metadata stored?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Enlist the tasks for which source qualifier transformation is used.
What do you mean by blocking transformation?
How can we use batches?
What are the components of the workflow manager?
Explain what are the different versions of informatica?
what is the -ve test case in your project.
explan ur project architecture?
What are 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?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How do you migrate data from one environment to another?
What is sorter transformation?
