Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

Answers were Sorted based on User's Feedback



How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

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

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

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

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

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

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

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

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

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

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

Answer / jatin marwaha

Use Dynamic Lookup on target table

Is This Answer Correct ?    0 Yes 0 No

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

Answer / nithya

By having a dynamic lookup at the target table

Is This Answer Correct ?    0 Yes 0 No

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

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

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and ..

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

Post New Answer

More Informatica Interview Questions

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,


Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  


What is staging area?

11 Answers  


What is rank transform?

0 Answers  


I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  


What do you understand by a term domain?

0 Answers  


What is a test load?

1 Answers  


What is the meaning of decode in informatica?

0 Answers  


Explain the difference between mapping parameter and mapping variable?

0 Answers  


How to compare Source and Target table, without using dynamic lookup?

4 Answers  


how we do performence tuning in informatica

3 Answers  


if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  


Categories