Informatica - In case of use of dynamic lookup cache in a lookup transformation, the lookup cache gets updated fir

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 586 of 644

In case of use of dynamic lookup cache in a lookup transformation, the lookup cache gets updated first and then the target table. What happens if the target table rejects a row after it is updated in the Cache?

Total Answers and Comments: 3

Last Update: May 27, 2008 Asked by: Savitha

Sponsored Links

Best Rated Answer

—

Submitted by: ggazulas

You wont get an error if the row is inserted in dynamic cache and it was rejected in the target table.
But remember we are refering to the same table in dynamic chache, so if it is inserted in the chache then it must be inserted in the target.

In mapping we have to handle to synch the chache with the target. informatica wont do this.

There will be new port row by default if we chose dynamic chache, if it is "0" indicates informatica wont update/insert the row in the chache.
if it is "1" then informatica inserts the row in the chache.
if it is "2" then informatica update the row in the chache.
based on this port we have to synch the target.

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

November 25, 2007 23:39:34

Rambabu.Gali

RE: In case of use of dynamic lookup cache in a lookup...

I think the Dynamic lookup cache contains the replica of the target table. According to my knowledge updation happens first in target table then in the lookup cache.

Is this answer useful? Yes | No

0 2

Overall Rating: -2

November 26, 2007 02:50:33

prakash

RE: In case of use of dynamic lookup cache in a lookup...

Data in the target table does syncronize. here you wont get any error but the result will not so accurate. so update it in the trg or you can use update strategy transformation as insert after lookup

Is this answer useful? Yes | No

May 27, 2008 10:13:59

ggazulas

Member Since: May 2008 Contribution: 6

RE: In case of use of dynamic lookup cache in a lookup transformation, the lookup cache gets updated first and then the target table. What happens if the target table rejects a row after it is updated in the Cache?

You wont get an error if the row is inserted in dynamic cache and it was rejected in the target table.
But remember we are refering to the same table in dynamic chache so if it is inserted in the chache then it must be inserted in the target.

In mapping we have to handle to synch the chache with the target. informatica wont do this.

There will be new port row by default if we chose dynamic chache if it is "0" indicates informatica wont update/insert the row in the chache.
if it is "1" then informatica inserts the row in the chache.
if it is "2" then informatica update the row in the chache.
based on this port we have to synch the target.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank