IICS | Remove Symbols & Non Printable or Untranslatable Char From Input Data in Informatica Cloud

[@pullaiahgarlapati4062]

Thank you for upload this video . Pls upload more real time scenario videos.

[@rameshp6212]

Hi Roshan, Thank you for all real time scenarios. Can you pls do video on how to run any task 3 consecutive runs and 4th run should be failed in iics?

[@ujjwalbadhe6086]

Thanks for this video Roshan❤❤❤ Much informative...🎉

[@ETLSTATION]

you r welcome . thank you for watching

[@ashishkumarwankhede9692]

Q. If a flat file coming like below and we have to load A,B,C column to target how we can do it? 1day A B C column 2day A B C D column 3rd day randomly data coming with different order column C A D B Column Q. Amazon S3 have zip file and you want to move it to oracle data base how we can do it?

[@ETLSTATION]

option A looks tricky for iics or powercenter, will see what are option and let u know second question : we will cover it when we go jobs related to amazon stay tuned

[@pavankumar-d7l2s]

Hello Roshan, u mentioned something 'flag' as 1 what that mean

[@ETLSTATION]

Optional Description CaseFlag Required Must be an integer. Determines whether the arguments in this function are case sensitive. You can enter any valid transformation expression. When CaseFlag is a number other than 0, the function is case sensitive. When CaseFlag is a null value or 0, the function is not case sensitive.

[@viks7627]

Are there any inbuilt functions in IICS to remove special characters and non printable characters?

[@ETLSTATION]

i dont think so , you may read their pdf but i have not come across any

[@rudrac3625]

Hi bro 😊

[@ETLSTATION]

yes tell me do you have doubt on something

[@JayapalReddyM]

Can you provide informatica 10.2 / 10.4 software

[@ETLSTATION]

its free right , you can download from oracle.com , free version , it will not have all the features but enough for learning , when i start powercenter series then i will show you what options it has , i am going to use that version only . there are many videos on youtube how to get that feom oracle website

[@ETLSTATION]

for example , watch this video and you can install it in ur local , i had done long long back in my system kzbin.info/www/bejne/Y3u4f2mGjraklac

[@ETLSTATION]

another one , there are many videos kzbin.info/www/bejne/jHy9coGIqcageqs

[@JayapalReddyM]

I need both IDQ / power center

[@JayapalReddyM]

I think oracle site have only power centre , correct me if I wrong