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
- 12559 Views
- Barclays, I also Faced
- E-Mail Answers
Answer Posted / singam srini
Hi
who replied the answer to given qs.. they were wrong..
please read the qs properly then reply ok..
sameer said same sequence generator..
deepak said reusable transformation(seq gen) and mappet..
how can we implement same seq gen t/r in different repositories..?
is it possible..?
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are mapplets? How is it different from a Reusable Transformation?
How do you promote a non-reusable transformation to reusable transformation?
Parameter and variable differences
Is there any way to read the ms excel datas directly into informatica?
How can we use mapping variables in informatica? Where do we use them?
generate date / time dimension in informatica
Tell me about MD5 functions in informatica
how to load dimension table and fact table. plz tell me the steps.
What is the sequence generator transformation in informatica?
Explain joiner transformation in informatica
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?
can we override a native sql query within informatica? Where do we do it? How do we do it?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is complex mapping?
What is sequence generator transformation in informatica?
