Rambabu.Gali

• Nov 25th, 2007

 

Simple Mr Madhu,

Take a dynamic lookup on the target table and  compare the values of target and source in an expression and flag the values so that you can update or insert.

Now in Informatica 8.1 there is a newly added function is there to avoid to do all these stuff.

For ex:

if u have some values like 101,102,103 in target, look up on target will get the values, and connect to an expression and connect the ports comming from source also and then compare those values... if there is any change in any column then flag that value with Y or N. and filter accordingly.

hemachandra

 Profile Answers by hemachandra 

• Dec 23rd, 2007

 

Hi Rambabu

what is that feature in informatica 8 which you mentioned, could you please explain it, i want to know the additional new feature

it will be very helpful - thanks

h02kkvel

 Profile Answers by h02kkvel 

• May 15th, 2008

 

Hi rambabu,
                    what the answer you have given is woring. if you dont have any primary key in your target table then how will you update the table. since update stratergy t/r works on primary key column only. without pk it is not possible.

the simple answer is first define a primary key (any one column)in your informatica metadata.(no need in database). then update the target.

regards
kiran

vivek1708

 Profile Answers by vivek1708 

• Jul 30th, 2008

 

It is true - that it wont work without the keys - dynamic look up and update but if the combination of the columns used for look up always returns a unique value - the update shall still work, even if the keys are not defined.

avneeshrathor

 Profile Answers by avneeshrathor 

• Nov 3rd, 2009

 

Use target update override and write down your SQL update statement there. It will not require any keys. Before that use whatever to identify which row qualifies for an update and which not.