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
- 3086 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 junk dimention?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
Can you access a repository created in previous version of Informatica?
what is semi-additive fact?where did u used?
1 lac of flat fles in source how to load target at a time?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
What is a node in Informatica?
What will be the approach?
What are the new features of Power Center 5.0?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
How can we integrate different flat file data in a single mapping and with in a single execution
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
Teradata 
