IICS Informatica Tutorial : Dynamic Mapping Task : Use Source ,Target as Parameter

Hi Friends , in this video , we will learn how we can use Dynamic Mapping Task to load many tables using single mapping , even the audit columns can be parameterized . its very useful .
Please check out below videos on how to create Mapping Task :
• IICS | Create First Ma...
Please check out below videos on how to create Taskflow :
• IICS | Create First T...

[@ETLSTATION]

Hi Friends Thank you for watching my video . Please subscribe to my channel like it and share it with your friends . also comment if you get any doubt on video , i will try to answer your doubt

[@rakshaughade341]

What if the source structure changes, but I need to map it to a fixed target table with a constant column structure? Will it still work in that case?

[@mram1690]

hi i follow same process which you explain that one i was run job it is successfully but it is emp table is loaded zero records others tables like dept & salgrade loaded successfully can you guide me please what is the problem.

[@AnupSangli]

Could you please explain how these table names are determined in your setup?

[@krish-7893]

Source object parmeterization for more Tables need this dynamic mapping task??

[@ETLSTATION]

thats right if many tables are there and we want to create single job this is way . there is another appproach but that is complex , you can read here knowledge.informatica.com/s/article/Load-Multiple-Tables-using-Reusable-Templates?language=en_US

[@krish-7893]

Thank you.. Best course u provided In power center.. How we do this one?? One of interview I faced this question. He asking the difference between power center and iics?? How they are different when we develop this type scenarios like that he asking

[@ETLSTATION]

@@krish-7893 in powercenter u can not do this much of paramterion like dynamic mapping task , there only paramter u can do if source has same structure then given source name in parameter file . iics is far advanced

[@ETLSTATION]

anyway i am going to launch powercenter series this week , thats why becoz i know every comapny wants ppl to know powercenter idq and iics all three nowdays

[@AnkitTiwari-fj4sr]

Nice explanation bro

[@daisysinghal1435]

after all the steps followed.. it is showing invalid dynamic task.. How to find out the error

[@nxashraf7266]

Could you please tell me. What is the Aduit columns

[@ETLSTATION]

audit columns like session load date , system name etc which does not come from source , you derive and load in target

[@nxashraf7266]

@@ETLSTATION got it 🙏

[@nxashraf7266]

@@ETLSTATION one more thing. Could you please tell me the most commonly used in built functions in IICS.

[@ETLSTATION]

@@nxashraf7266 that depends on your project and requirement , if you watch all my video then u will come to know , examples are trim functions , datatype conversion functions like to_char ,to_integer, to_date etc

[@nxashraf7266]

@@ETLSTATION I will go through that. Thanks 😊👍

[@anilkumarakc1046]

What are steps should follow migrating pc to iics(please make a video)

[@ETLSTATION]

check out this video for importing powercenter workflow as powercenter task in iics kzbin.info/www/bejne/gqDOZ2edbKqZpqs

[@thenotorious0606]

How to create a source dynamically from column value?

[@ETLSTATION]

source or target , you can only create some target files using column values by passing expression . you may use them as source for other jobs .

[@thenotorious0606]

@@ETLSTATION I'm trying to create a dq framework using aggregator and I'll pick up table names from control tables/metadata register then put them under threshold checks. There is a column in this control table called table name , is there a way I can use it to create a source dynamically and execute the dq checks? Thanks for replying though

[@ujjwalbadhe6086]

Perfect!

[@ETLSTATION]

thank you , keep watching

[@anilkumarakc1046]

Super explanation

[@ETLSTATION]

Thank you Anil

[@GoodMindGoodFind]

nice video.. 👍🏻

[@ETLSTATION]

Thank you for your comment , please go through my other videos as well .

[@chetansaini8348]

nice video

[@ETLSTATION]

thank you chetan , keep watching all other videos in my channels

[@nikhilchavan8890]

HOW TO CREATE TARGET AT RUNTIME IN DYNAMIC MAPPING TASK?

[@ETLSTATION]

here u can follow this , i think i have covered similar thing in how to add timestamp in file video. here its just that assign to paramter values knowledge.informatica.com/s/article/HOW-TO-Generate-target-at-runtime-using-Dynamic-mapping-task-in-Cloud-Data-Integration?language=en_US

[@KumarAnil-fx6lq]

bro cloud you explain any realtime scenioar in dynamic mapping task(please make video)

[@ETLSTATION]

Hi Anil , in this video its kind of real time only . the only difference would be instead of 3 tables , it could be 50 tables or 100 tables which you have to define using jobs then group them accordingly to run in sequence . concept is same . all dependent tables should run after main table . for example : if employee table has a key called emp id which is foreign key for child table like employee adress , employee city , department, sales etc , then employee table should be group 1 and all child tables should be loaded in group2 , they all can run parallel because employee table is already completed.