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
- 15357 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 |
What is galaxy shema
How to do Integration testing in Informatica?
How the facts will be loaded? explain
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
 Informatica Checkpoints
How to Join Tables my Source is having 15 table target is one?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Hi All can anyone tell me where i will get Informatica training in Mumbai?
Name 4 output files that informatica server creates during session running?
When you move from devel to prod how will you retain a variable
Teradata 
