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
- 14967 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 |
How to load last 10 records of flat file in to the target?
How would you join a node to the already existing domain?
what is the predefined port in dynamic lookup
What are the types of schemas we have in data warehouse and what are the difference between them?
If I have a index defined on target table and if set it to bulk load will it work ?
What is union transformation?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
comonly how meny mappings r there in Banking projects?
what is the look up transformation?
how we load the data from source to staging area
connected and unconnected lookups?
Write the program through which the records can be updated?
Teradata 
