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
- 2992 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 |
What is IQD file?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
difference between repository database and repository service?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
Why do you use Mapping Parameter and mapping variable?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
All active transformations r passive or not?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
While migrating the data from one environment to another environment how would you manage the connections?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
On which transformations you created partitions in your project?
Teradata 
