how to use incremental load?
- 2 Answers
- 8257 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Whenever an OLTP records update or insert in the source
,then the records are loaded in to target as a new record.
Using SCD type 2 we can acheive the incremental load.
If it wrong means chandranmca2007@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / moorthy g
Source --->SQ ----> Expression ---> Target
===> Create Mapping Variable
===> In SQ use sql override
where startdate < $$date
====> In expression use variable port,
setmaxvariable($$date, startdate)
=====================================
You can find variable value in Log fine and session RC you
can find it.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is a connected transformation?
what is $$$$?
why we use datawarehouse
Quickly characterize reusable change?
What is a filter transformation?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
how i will stop my workflow after 10 errors
How union transformation is active ?
How to do Integration testing in Informatica?
Do you have to change the reject file b4 using reject loader utility.
What is a repository manager?
How we can confirm all mappings in the repository simultaneously?
Teradata 
