IICS | Incremental data load - simplified version | #informatica

IICS | Incremental Data Load - simplified version
2. Mapping Implementation
1. Define Mapping variable - $$max_hire_date
2. Source/Source Qualifier [EMP] Defined query to filter $$max_hire_date
3. Expression transformation — SETMAXVARIABLE($$max_hire_date,hiredate)
4. Target - [T_EMP]

[RealRecker]

How to do incremental load with a rest API source having from date and todate as API parameters ?

[mubinahmad]

If the job fails in between loading of data, what would be the variable value, what it was holding before the job run? or what it picked in the current run at the time of failure? Is there a way to override the mapping variable value?

[srikanthdanda]

Hi, Do we really need to use filter transformation and filter after expression. Using set max variable we are assigning max of value to the mapping variable and the value is going to be applied in source qualifier to pull only incremental data sets correct?

[RiteshGatpalli]

sir one major question, how you got iics running on a mac. as i saw that secure agent is only supported on windows and linux ?

[pullaiahmaddumala]

Dear Sir - I have implemented the same approach but the incremental data ans whole data is extracted and the only new records inserted but the other records error occurred due to constraint.

We nedd to pick only the new records.

We have LastModifiedDate and Created Date.

Kindly help where I did the mistake.

[rsntechnologies]

Static cache vs Dynamic cache in which scenario we can go with Dynamic? .In which scenario you will use Static?

[karanrajkasat]

How to parameterized source connection in mapping task?

[PradeepKanaparthy]

sir, will $$max_hire_date remain for all/any runs without reset to default?

[pullaiahmaddumala]

Sir still the value we define that one only assigning in fitler. The max variable holding the correct value buy while delta still picking whole records. Pls assist me 🎉

[dhaswaktheterrificboy]

Here source is db if suppose source is flat file then how to do cdc on date column

[slyroy]

What if we don't define default value for mapping variable. Which value it will pick if we don't define the value

[vijayalakshmikg]

Hello Sir am trying to $lastrundate system variable in IICS for my incremental . How do I query $lastrundate - 1 ? Appreciate your response ..