IICS | Read Excel File using Structure Parser 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

[@sufians6975]

Roshan, your videos with explanations are very articulate and coherently.

[@ETLSTATION]

thank you sufian for your feedback. keep watching

[@chenv7413]

Very Well explained dear Keep it up

[@ETLSTATION]

Thank you chen for providing feedback . please check my other videos as well and wait for more videos in iics

[@pril172k24]

Your explanation is well and understood!!👍

[@ETLSTATION]

Thank you shivaji . keep supporting and watching

[@RaviKumar-rq1kn]

Hi Roshan, You are making complete Information about IICS. Can you make migration project from PowerCenter to IICS with small data. If you done it will be more useful because now a day all clients are moving to cloud, So all are replacing the PowerCenter with IICS. Now Informatica also not supporting much for the PowerCenter version 10.5 onwards. All the Best. I hope you create soon.

[@ETLSTATION]

that would need license because powercenter to cloud conversation option is not avaialble in free version in which we practice . other option to export workflow xml to run in iics i already covered in one video .

[@RaviKumar-rq1kn]

Hi Roshan, If possible make the videos on new Transformations added in IDMC i.e Verifier, Duplicate, Cleanse, Parser, Mapplets and Rule Specification.

[@ETLSTATION]

will see if they r in free version then will add in future

[@bsaivamsi]

An curious to know about that loading unidentified checkbox. How often you seen this unidentified data in your experience. If its structure is unidentified how IICS load it. If we are loading everything in same table?

[@BeastmovitateX]

As currently we are loading the sap tab in sap target table and oracle tab in oracle target table. What if we can have single target table and load both sap and oracle table in that particular table ?

[@ETLSTATION]

ya now you commented on right video , you can laod on same table no issue as long source and target structure is same . no issue

[@BeastmovitateX]

@@ETLSTATION thanks for your response! Great job

[@Bhushan-s7c]

hi sir how to handle header and footer of excel sheet in iics and can we handle header and footer in ism in iics.

[@ETLSTATION]

what error you get when excel has footer or header

[@FaisalMasood-q6g]

Intelligent structure model is not available in IICS IN Free version now under component section i tried.