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 / ora_001
Can we use merge here ?
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
EXL informatica Questions
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the new features of informatica 9.x at the developer level?
Explain incremental aggregation in informatica
What is informatica powercenter repository?
What is mapplet in informatica?
Can we create multiple integration service on single repository?
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
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is Active lock explain
What does refresh system mean, and what are its distinctive choice?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the tuning techniques you applied during your last project
What is domain and gateway node?
Performance tuning in UNIX for informatica mappings?