HOW DO YOU PARFORM INCREMENTAL LAOD ?
- 7 Answers
- 14529 Views
- SAIC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subbu
by using the date coll in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / praveen
Taking the Target defination as source and using the joiner
and update we can do the incremental loading
2.By using lookup transformation, keeping lookup on target
and companring.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / tshiwela
you can perform increamental load by using auxiliary
parameters.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sudhakar
BY USING MAPPINING VARIABLES,FIRST DEFINE THE VARIABLE
E.DATE AND NEXT COMPARE E.DATE,IF IT MATCHES THEN DATA
AUTOMATICALLY LOADED.
| Is This Answer Correct ? | 0 Yes | 0 No |
By using the date column in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
With this in mind, I will expect a load pattern like this
Every extract from the source will be a full load
Every load in terms of records, will be equal to last load + new records – deleted records
80-90 % of the extracted records will already exist in the valid table instance
Every load will be incrementally larger than the previous load, as more records are added to the sourceThinking
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vaschiky
Disable truncate target table option from session target
table properties.
| Is This Answer Correct ? | 0 Yes | 0 No |
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?
What is the query to find nth highest salary? What is the use of cursors?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
How many repositories can we create in Informatica?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
how we can do session partition in informatica any one explain me clearly? thanks advance.
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
how to identify new and old values in source qualifier or any other transformations using informatica
Explain the difference between a data warehouse and a data mart?
What is the meaning of up gradation of repository?
How to recover sessions in concurrent batches?
Teradata 
