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
- 2971 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 |
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
What are the informatica performance improvement tips
explain abt joiner t/r?
What is a stored procedure transformation?
how can we load starting with 11th record of a table from source to target
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
in which situations do u go for sequence generator ?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
Difference between session variables and workflow variables?
Teradata 
