Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 11152 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is expression transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Can you generate sequence numbers without using the sequence generator transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
how to load dimension table and fact table. plz tell me the steps.
What is a code page?
How are indexes created after completing the load process?
Enlist the various types of transformations.
Explain sql transformation in script mode examples in informatica
What are Dimensional table?
What is target designer and target load order?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to generate or load values in to the target table based on a column value using informatica etl tool.
