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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Performance tuning in UNIX for informatica mappings?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the status code in stored procedure transformation?
Which version configuration tool used in ur project?
What are the different components of powercenter?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Mention some types of transformation?
What is workflow? What are the components of the workflow manager?
What do mean by local and global repository?
Different sorts of metadata that stores in the storage facility?
What are the tasks that can be performed using sq?
What is Data Caches size?
How to extract the informatica rejected data?