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
- 14963 Views
- Barclays, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sameer rana
We can maintain a unique surrogate key if we use the same
sequence generator to generate the key.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / rajesh aitha
Hello all,
We can use one Seq by creating reusable transformation in one repository folder and make the repository folder as shared folder.
But one constraint is there the in the question is all about to maintain the uniq key, being a challenge.
I have a suggestion to append a string for each record that is to maintain as S.key in the mapping it self.
like wf -1 will insert 1234A and wf -2 will insert 1235B as uniq key.
I suggest to know the exact functionality of Seq ...:-)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / deepak
Create a sequence generator transformation in transformation developer and use this transformation instead of using separate sequence generators. 2. Use mapplet and design
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
Answer / 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 |
Answer / 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 |
Where is the cache stored in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
checkout and checkin in informatica 8.6
scenario where i can use only concurrent execution of workflow.
when will we go for unconnected lookup transformation in Informatica?
What happens if we dont select data driven option?
Can we create a Integration service without a Repository service and vice versa?
normalizer transformation
What do you mean by blocking transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How can we handle two sessions in informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Teradata 
