1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

source table have 3 records? and it is sucessfully loaded
into target. and 4more records is added in to source .that
means 7 records now in source. we have to load the
remaining 4 records into the same trgt table with maintian
top 3 records. how ?can any one give me the data flow of
this logic plz?

Question Posted / sbvp

Answers were Sorted based on User's Feedback



source table have 3 records? and it is sucessfully loaded into target. and 4more records is added ..

Answer / ap

Use the target table as lookup and check for the existance
of the rows from source in the lookup. If the row already
exists then ignore and only pass the new rows to the target.

Is This Answer Correct ?    18 Yes 3 No

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added ..

Answer / vinod

Use Update Strategy Transformation. Identity an unique
field or an unique combination which is the primary key.
Check the primary key field or combination field in Update
stratergy based on which the target is updated. If the key
from the source matches with the target key field, then
these rows not inserted into the target, else it gets
inserted

Correct me if I am wrong

Is This Answer Correct ?    11 Yes 0 No

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added ..

Answer / kishore

Hi this will do by using INCREMENTAL LOADING.
We should delete records on staging area by using presql on
target(staging).
now staging having only new records..

Is This Answer Correct ?    2 Yes 8 No

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added ..

Answer / ora_001

Can we use merge here ?

Is This Answer Correct ?    0 Yes 6 No

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added ..

Answer / ajit

just give truncate table option in session properties of
target table.if you dont want to delete the old records and
load from 4th record onwards then you have to use sequence
generator and filter give key>=4

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More Informatica Interview Questions

How to use Normalizer transformation?

2 Answers  

Write the unconnected lookup syntax?

0 Answers  

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

What is predefined event?

1 Answers  

What are the modules in Power Center

0 Answers  




tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

What is dimensional table? Explain the different dimensions.

0 Answers  

how to declare array in plsql?

1 Answers  

when informatica 8 series released ?

1 Answers   IBM,

difference between shortcut and reusable transformation?

2 Answers  

How do you handle two sessions in Informatica

0 Answers   Informatica,

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

For more Informatica Interview Questions Click Here
Categories