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
- 15413 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / sanjeev
Mapping 1: we will use sequence generator, if key value is null then we will pass nextval else will find maximum of key value then will increment by 1
Mapping 2: same as above
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Can we create a Integration service without a Repository service and vice versa?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are mapplets? How is it different from a Reusable Transformation?
What are the different clients of powercenter?
Quickly characterize reusable change?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to update source definition?
Explain what transformation and how many are there in informatica?
What do you mean by blocking transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Why is sorter an active transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
What is the status code in stored procedure transformation?
What are the issues you have faced in your project? How did you overcome those issues?
