Interested to Buy Any Domain ? << Click Here >> for more details...
On a day i load 10 rows in my target and on nextday i get 10
more rows to add in target. But out of 10 - 5 records are
send them to target?how i can insert the remaining records
- 1 Answers
- 2969 Views
- I also Faced
- E-Mail Answers
Answer / nayek007
1. If stage table have some unique identifier then lookup wrt target table and skip the already inserted rows.
2. Use a flag in stage area..update that record when inserted into target table...and in sq filter the data set using that field.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the meaning of decode in informatica?
What is the difference between a table and the materialized view?
can every transfomation reusable?how?
enterprise datawarehouse your project phase by phase explain?
Differentiate between joiner and lookup transformation?
What is Collect performance data in informatica and what is the use of it.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
what is mapping parameter?
What happens if the info. Server doesn't find the session parameter in the parameter file?
Teradata 
