how to use incremental load?
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 an MDDB? What is the difference between MDDBs and RDBMSs?
can we use bulk loading when we use look in mapping
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
Tell me about MD5 functions in informatica
Differentiate between joiner and lookup transformation?
what transformations are used for Variable port?
What are the parts of Informatica Server?
Sequence generator, when you move from develoment to production how will you reset
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
What are the transformations that are not supported in mapplet?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail