When we are having data in the target table and there are no primary key or foreign key mentioned in the target table then how will you update as well as insert the data?
RE: When we are having data in the target table and th...
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.
RE: When we are having data in the target table and there are no primary key or foreign key mentioned in the target table then how will you update as well as insert the data?
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
RE: When we are having data in the target table and there are no primary key or foreign key mentioned in the target table then how will you update as well as insert the data?
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.
RE: When we are having data in the target table and there are no primary key or foreign key mentioned in the target table then how will you update as well as insert the data?
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.
0 
1