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
- 3072 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 |
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
What are the new features of informatica 9.x developer?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
what are challenges that you faced in testing? give solution to it?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
what is the need of session partitioning... how it is useful in real time
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
What are the different types of Type2 dimension maping?
How does the server recognize the source and target databases. Elaborate on this.
What are the diffrences between joiner transformation and source qualifier transformation?
What is a sorter transformation?
Teradata 
