Informatica - When we are having data in the target table and there are no primary key or foreign key mentioned in

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 582 of 644

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?

Total Answers and Comments: 5

Last Update: November 03, 2009 Asked by: madhu2732

Sponsored Links

Best Rated Answer

—

Submitted by: vivek1708

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.

Above answer was rated as good by the following members:
vasirev

November 25, 2007 23:35:28

Rambabu.Gali

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.

Is this answer useful? Yes | No

0 2

Overall Rating: -2

December 23, 2007 17:42:02

hemachandra

Member Since: September 2005 Contribution: 4

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

it will be very helpful - thanks

Is this answer useful? Yes | No

May 15, 2008 04:33:25

h02kkvel

Member Since: May 2008 Contribution: 3

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.

regards
kiran

Is this answer useful? Yes | No

0 1

Overall Rating: -1

July 30, 2008 00:19:36

vivek1708

Member Since: May 2008 Contribution: 18

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.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

November 03, 2009 12:03:45

avneeshrathor

Member Since: November 2009 Contribution: 7

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?

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank