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
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 update strategy transform?
What are mapping parametres and variables in informatica?
How can informatica be used for an organization?
why union is active transformation?
Can you generate reports in Informatcia?
What is confirmed dimension?
What is lookup transformation?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
Do joiner transformation use cache? If so describe?
If u select groupby port in aggregator what is output and dont select groupby option what is output
What do mean by local and global repository?