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 |
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
can we load the data with out a primary key of a table? what is target plan?
In a sequential batch can you run the session if previous session fails?
What is the Difference between SetVariable and setmaxvariable in informatica?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to create Target definition for flat files?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
can we have to do changes in session property when we are dynamically generating target files?
What is difference between partioning of relatonal target and partitioning of file targets?
What are the join types in joiner transformation?
What is aggregate awareness?