IICS | Incremental Load using IN-OUT Parameter or Mapping Variable Method in Informatica Cloud

[@bradyb2415]

so we can use the IN-OUT parameter field as a audit column and can be used this incremental loading purpose right?.is it ok if the text file is deleted after the mapping task is finished and updated variable value in inout parameter still persistent or wiped ?

[@ETLSTATION]

after we copied the text file value to param file , it can be deleted , its of not any use , because in out param value is stored in informatica repository, it will write the file again

[@VenkatReddy-zo3kx]

Roshan thanks for the video, but is there any way to load incremental data without any audit columns(date columns) in source. if it is there kindly make a video on it. thanks in advance

[@Adikes_InfoTech]

Hi Roshan, I have a small doubt, I hope you can reply on this. Which authentication type will use in real time for snowflake connection in IICS? And for incremental load if the source records are deleted permanently after loading into target. How can we check those deleted records in Target and delete as well from target table?

[@dakshssarapuregamingandpia9443]

Task getting failed and in session log This is the error massage. (I have used IN-OUT Param). argument 2 to function TO_TIMESTAMP_NTZ needs to be an integer, found: ''YYYY-MM-DD HH24:MI:SS'' Video no 67. How to resolve?

[@ajayaj470]

Most of the places audio is not clear 😢😢😢

[@ETLSTATION]

sorry , try to watch other videos .

[@Adikes_InfoTech]

I just want to tell you one thing, please improve your mic quality. Apart from this all your videos are superb.... It really helps a lot!!!!!!!!!!!

[@ETLSTATION]

👍🏻

[@ramjan135]

@@ETLSTATION can you pls make a video, considering source as SAP for incremental load. I'm not able to cross check date format which is accepted by SAP .