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
What are the popular informatica products?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the transformations that are not supported in mapplet?
What is the advantage of informatica?
explain one complex mapping with logic? sales project?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain what are the different versions of informatica?
Differences between connected and unconnected lookup?
explan ur project architecture?
How do you load alternate records into different tables through mapping flow?
Clarify the aggregator change?
How to extract sap data using informatica?
Under which circumstances, informatica server creates reject files?
What all join we can perform in LOOKUP transformation?