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?

Showing Answers 1 - 15 of 15 Answers

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.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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

  • 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.

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions