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
- 3047 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 |
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
How do you use reject loader.
can we use bulk loading when we use look in mapping
What is the difference between IN and Exists in Oracle?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
In a table, 4 person having same salary. How to get Third person record only?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is mean by throghput? in informatica
Global and Local shortcuts. Advantages.
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
what is normalization? explain 1st NF, 2nd NF, 3rd NF
Teradata 
