IICS | Get LAST and FIRST Row in Informatica Cloud

[@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

[@kamasanichittibabu5013]

How to get both first and last row

[@sivareddy0914]

Hi Roshan, I am following ur videos ..ur way explanation is good..Can you do one video on removing duplicates by using dynamic lookup?

[@ETLSTATION]

hi shiva , thank you for your comment, ya we can do it , will create video on that , meanwhile watch all duplicate remove video series and other videos

[@ETLSTATION]

here it is , it will premiere on monday morning Dynamic Lookup in IICS Informatica Cloud and How to Remove Duplicate using it kzbin.info/www/bejne/pqSkZYGwjs6apqc

[@sivareddy0914]

@@ETLSTATION thank you for doing this

[@abhisheksinghzerothree9495]

Can you please explain why with help of aggregator transformation only last rows is coming what is the reason ??

[@ETLSTATION]

thats how its designed , when we pass through aggregator then it gives last row , use sorter before aggregator , or take maximum or minimum of each columnist in aggregator then it will work

[@syedshah5487]

@Roshan, please sir can you explain in the same mapping if we want to load first 3 rows and last 3rows , how we do that?

[@ETLSTATION]

i think we can take one expression with seq generator to router with two groups , both as true . then create two flows each with rank , one with top 3 another with bottom 3 and load into same table with 2 instances. need to test it if it works , but hi level this is what comes to my mind as of now .

[@syedshah5487]

Thank you Sir@@ETLSTATION

[@anilkumarakc1046]

Sir please make video in source type(command )-unix script file to Excel file (target)

[@ETLSTATION]

i will see if i can do that since my trial version is on windows . i dont have unix