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?
Answer Posted / 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 View All Answers
How can you generate reports in informatica?
How do you take back up of repository?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what are 3 tech challenges/ common issues you face?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Global and Local shortcuts. Advantages.
What is sorter transformation?
Have you worked with/created Parameter file
differences between service based and product based?
Clarify the utilization of aggregator cache record?
What is the difference between stop and abort in informatica
Explain the different lookup methods used in informatica?
What is resilience time?
how tokens will generate?
can any one give some examples for pre sql and post sql(Except dropping and creating index).