Interested to Buy Any Domain ? << Click Here >> for more details...
HOW DO YOU PARFORM INCREMENTAL LAOD ?
- 7 Answers
- 16737 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 |
what is the dashbords?
how to calculate the optimum cache size in aggregator transformation?
What are the disadvantages of Sequence Generator T/R?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
Write the unconnected lookup syntax and how to return more than one column.
Router T/R is active but some people are saying it is also passive which is exactly right?
What is the advantage of persistent cache? When it should be used.
HOW TO YOU LOAD TIME DIMENSION
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
when we use dynamic lookup,if condition matches what will be the o/p?
how to get the only updated records in the target
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
Teradata 
