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
Explain the tuning lookup transformation - informatica
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Mention some types of transformation?
What is domain and gateway node?
Can we create two repositories on same database instance in oracle?
Explain joiner transformation in informatica
What can we do to improve the performance of informatica aggregator transformation?
What is lookup transformation?
What is informatica powercenter repository?
Differentiate between router and filter transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Under which circumstances, informatica server creates reject files?
Write the unconnected lookup syntax?
How to create Target definition for flat files?