Informatica Tutorial for Beginners | Informatica complete tutorial | Informatica interview questions

[@NICITACADEMY]

🌐 *Register IICS/IDMC/Cloud - Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ 🌐 *Are you interested in joining my Live training? or Self-Paced course?* www.nicitacademy.com/ ✅ *WhatsApp Group for Informatica technical discussion* chat.whatsapp.com/JXCF1i06BCS64JqE0L209r ☎Contact us for more details WhatsApp: @[phone] 🌕 wa.link/m4lat0 Direct call & WhatsApp: [phone] *Oracle SQL Playlist* kzbin.info/aero/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF *Informatica PowerCenter Playlist* kzbin.info/aero/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd *Informatica IICS Playlist* kzbin.info/aero/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj *Oracle PLSQL Playlist* kzbin.info/aero/PLsphD3EpR7F_mXwcliOLEmnNUB7ZpxGdB *Microsoft Azure Playlist* kzbin.info/aero/PLsphD3EpR7F8_sOED5d2oS6cIpCwOBjMV *Oracle SQL - தமிழில்* kzbin.info/aero/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 *Informatica PowerCenter - தமிழில்* kzbin.info/aero/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3&si=pxEnhkIPT3IkQ-R9 Thanks, NiC IT Academy

[@chiruchowdary6044]

Sir now a days all are giving the courses with money based only..but you are uploaded it free of cost through this KZbin channel.. Thank you soooooo much sir

[@NICITACADEMY]

Thanks and welcome. Keep watchin my channel and videos.

[@saivasepalli6008]

Thank you sir, your videos are easy to understand and implement. I installed informatica 10.2, oracle and IICS by watching your videos. Implemented all the transformations from your video. This journey with Informatica training and implementation inspiring me to dive deep. Once again thank you.

[@NICITACADEMY]

Thank you. Keep watching my channel.

[@chaitanyareddy5567]

It helped a lot in my job. Very useful and informative videos. Thank you for your effort.

[@NICITACADEMY]

You are welcome! Keep watching my channel.

[@vineethguduru199]

Great sir. Add the timestamps. That would help.

[@blrshekhar9811]

Hi Sir, Thank you for explaining and teaching INFORMATICA ...

[@vikaskumar-qr5tj]

Fabulous sir all content at one place♥️

[@NICITACADEMY]

Thanks, Keep watching.

[@jyothikathi7192]

YOUR EXPLANATION IS AWESOME . TQ 👍👍👌👌

[@NICITACADEMY]

Thanks

[@pavandadi9076]

Thank you so much bro. By watching your videos I cleared tcs digital. ❤😊

[@NICITACADEMY]

Most welcome 😊I am happy to see such a wonderful feedback again. :)

[@ratheeshkannan2360]

@pavandadi9076 Do u have any resource to prepare for mcq.

[@Basva780]

Thank you sir for you clear explanation on Informatica tool. Everything was clearly explained with examples.

[@NICITACADEMY]

📌Please visit our website for interview questions nicitacademy.com/ 📞For more details contact me on WhatsApp [phone]) or the below link wa.link/m4lat0 📞 Direct call & WhatsApp @ [phone] 🌕 wa.link/8szdvc

[@subbareddyvenkat]

Great session's

[@NICITACADEMY]

Thank You

[@yuvrajborase558]

Done with 10 hr series, Thanks for such useful content

[@NICITACADEMY]

Nice work!

[@tejateja6523]

Your teaching is excellent sir thank you sir

[@NICITACADEMY]

Thanks 🙏 Keep watching

[@My-Research]

nice video sir

[@NICITACADEMY]

Thanks and welcome

[@nandhinibhaskar97]

Thank you sir. your explanation is very clear and easy to understand..

[@NICITACADEMY]

You are most welcome

[@yashaswinishrigopalan9717]

Clear explanation. Thank you so much

[@NICITACADEMY]

You are welcome

[@guruguru6472]

Dear Sir, thank u so much for uploading this video. Wonderful Detailed Session. Really helped a lot.💯💯💯

[@NICITACADEMY]

It's my pleasure

[@madhavisucharitha7335]

Great Explanation sir ! Sir kindly share the transformation notes that would greatly help in summarizing all at once.

[@NICITACADEMY]

courses.nicitacademy.com/courses/Informatica-PowerCenter---Self-Paced-Training-64f0c8cbe4b09fcb108b8003-64f0c8cbe4b09fcb108b8003

[@sivabala4128]

Thank you somuch for giving great knowledge to us sir really thanks alotsir

[@NICITACADEMY]

Thanks and welcome. Please like and share my video.

[@ponnupradeepanee8805]

You are superb sirr 🙏🙏🙏🙏...Thank you soo much

[@NICITACADEMY]

So nice of you

[@EUK379]

Ekdam best teaching bro nice to learn here hope more videos from your side and subscribed 🤗

[@NICITACADEMY]

Thank you, keep watching my channel.

[@mukundam9428]

Thank you for the complete tutorial , easy to understand and learn.

[@NICITACADEMY]

You are welcome!

[@muppasanipremsai9074]

Thanks for the tutorial sir. Please do a full course tutorial on AWS and MS Azure from beginners to advanced.

[@NICITACADEMY]

Sure I will. Keep watching my channel.

[@lynnalhaimy]

Thank you! Great work

[@NICITACADEMY]

Thank you too!

[@AnilKumar-mp9hk]

Amazing n unbelievable

[@NICITACADEMY]

Thank You, Please like and share.

[@karansingh-dd2xv]

Sir how you create Target table in core to perform joiner operation in 3:48:00

[@NICITACADEMY]

Please watch my installation video in the playlist, I have explained how to create table in core schema.

[@phanikumar4300]

Thanks for the full course video NIC IT ACADEMY team and we are grateful for your efforts. Could you please upload a detail project in Informatica tool starting from staging, Data cleansing, Major transformations on LIVE project prespective, Code migration, Solving production issues, Performance tuning and testing

[@NICITACADEMY]

Please check Playlist videos, I already posted.

[@austinchettiar6784]

@@NICITACADEMY Hi I cannot find the exact playlist for the above , can you provide me the playlist link??

[@nixxy1074]

Massive respect for you.

[@NICITACADEMY]

Thank you very much

[@khadarbasha4776]

Sir your explanation is awesome and very useful. plz upload the notes in video link. thank you

[@sushmatetali2112]

Thanks for the tutorial sir. Please do a full course tutorial on AWS, and MS Azure in ENGLISH from beginners to advanced and how it will help in real-world problems. it will help us a lot.

[@NICITACADEMY]

Noted. Keep watching, Thanks for your valuable suggestion.

[@sabbaninaveenkumar1763]

Hi have currently working on aws or Azure

[@pavandadi9076]

Sir can you tell me how to load input data in reverse order using the expression transformation mentioned in that practice question.

[@vamsi.reddy1100]

Bahubali session 🙏🙏🙏

[@NICITACADEMY]

Thank You, Keep watching. Like and share.

[@arjitakashyap8169]

Please suggest if there is any online training classes for informatica power center the latest version

[@NICITACADEMY]

please contact me for online classes 📞For more details contact me on WhatsApp [phone]) or below link wa.link/m4lat0 📌 visit website for tutorial and interview questions www.nicitacademy.com/

[@neerajshukla6907]

Amazing lecture ... You are explaining everything crystal and clear so that any new person can understand informatica without any difficulty.

[@NICITACADEMY]

You're most welcome. Keep watching my channel.

[@syedkirmani9009]

Sir, I have not found the workflow task session in this video, Could you please guide is there any part 2 video..

[@ABQ...]

im currently learn etl testing but um having confusion about testing tools informatica Data Validation Option (DVO) vs informatica powercenter ... and this course covers informatica Data Validation Option (DVO) testing?..

[@venkey524]

Great explation

[@NICITACADEMY]

Glad it was helpful!

[@ayushkumarsingh5018]

Thanks a lot sir for this tutorial😀

[@NICITACADEMY]

Most welcome 😊

[@ajithh496]

Very nice

[@NICITACADEMY]

Thanks

[@karansingh-dd2xv]

Sir in 3:49:38 how you get T_dpartment table in core

[@NICITACADEMY]

Please watch my installation video in the playlist, I have explained how to create table in core schema.

[@rajasekhar8261]

Thanks for the tutorial sir. Please upload oracle complete tutorial also.

[@NICITACADEMY]

Sure I will

[@electricalproject1920]

Please make videos on informatica MDM

[@janarmp]

Sir your content and way of explanation is awesome. Could you please upload similar complete video on Oracle SQL, so that it will be helpful for many people. Thank you.

[@NICITACADEMY]

Sure, I will do.

[@pujasharma6805]

Hi Sir, Is this series is updated every topic of informatica. I have seen some different videos in informatica playlist. If more videos you publish. Please also update in this 10hour of videos

[@NICITACADEMY]

Thanks 👍 I ll do.

[@amanbodele1616]

Is this playlist enough to learn infromatica or do I need to find out other platforms as well

[@NICITACADEMY]

courses.nicitacademy.com/t/allcourses please check here

[@harithai8658]

Simply super and understanding every concept 👏 🙌. Thank you so much sir for your great efforts..

[@NICITACADEMY]

You're most welcome

[@s...2581]

HI Chandra ...What does it means read through mapping in informatica??

[@ShubhamPatil-cu1qo]

2:17:00 odbc connection

[@sivaranjanis8605]

Thanks a lot for your videos sir , it's really helpful 🙂👍

[@NICITACADEMY]

Most welcome!

[@niharikachinni922]

Thanks for the videos.. I really like the way you Explain.. can i have the download link

[@NICITACADEMY]

🌕For Live training contact me on WhatsApp [phone]) or below link wa.link/m4lat0

[@surajjanjirala2460]

Great Explanation going through your videos from 2 days everything is going perfectly but since yesterday informatica services is stopping automatically , informatica web page also not opening so not able to connect to the repository so could you provide solution for this error??

[@NICITACADEMY]

That means you have antivirus software in your system and it is removing the Informatica exe files after some days. so disable antivirus and re-install one more time

[@soujanyasaya3672]

Hi sir you told there will be a merrier data base which will hold 10 days data.. if we need the old data of more then 1 month for analysis what is the procedure

[@NICITACADEMY]

It ll be available in the data warehouse.

[@soumyaranjanpanigrahi2813]

thank you sir

[@NICITACADEMY]

Most welcome

[@UKJ28]

Is this course relevant today also or this is old course and there have been many changes in Informatica? Please do reply. Thank you in advance.

[@NICITACADEMY]

Yes the same concepts are applicable.

[@UKJ28]

@@NICITACADEMY ok. thank you.

[@ashokkumaryerra734]

Sir while crearing relational date in workflow manager it is showing words some are not visible clearly can u tell mee the solution what is rhe font size we need to select

[@triggershots8974]

Hello sir In between of course video u tell about table data and query will be given in description But there ia no such details

[@kommanajyothsna7646]

How does Informatica works on non shared filesystem on multiple nodes

[@charishmasingireddy5156]

sir did u attach the doc file which you were showing in the video

[@pemmasanigayathri5]

Hii sir Is informatica having demand in market? Is this course having growth in future sir? Please, reply

[@NICITACADEMY]

Yes we have demand for ETL, Cloud ETL(IICS) too.. AWS, Azure, GCP and all same ETL pipeline concepts. So please learn it.

[@prabhatgupta6415]

@@NICITACADEMY sir in my project iics is there to learn so do i need to learn powercenter first or shall i go for iics.let me know i am totally new to this informatica but have knowledge of cloud and dataware house

[@geetakegeet0520]

Its a great learning for me till now . Where can i get that notes explained in the video ?

[@IronMan_2.1]

4:26:36 Sir, do we need to make sessions for each and every mappings we will create while making a project which requires more than one transformation ???

[@NICITACADEMY]

Yes, For each mapping, we need to have session.

[@IronMan_2.1]

@@NICITACADEMY ok, thank you

[@sushmatetali2112]

Thanks for the tutorial sir. Please do a full course tutorial on AWS and MS Azure from beginners to advanced. It will help us a lot.

[@NICITACADEMY]

Sure I will

[@keepshining3068]

When will you upload AWS and Ms Azure please upload it asap

[@vineethmenon2372]

YES PLEASE

[@haricharangv]

sir, I am halfway through already in this course, very precise explanation of each and every topic by you sir thank you so much can I get jobs on Informatica after completing this course?

[@NICITACADEMY]

Yes definitely, Keep watching

[@SeekingSmiles236]

Did you get job?

[@rajareddy-rv4vh]

Hi sir good video Plz send class note for informatica sir

[@bharathkatabathini]

Thanks a Ton sir....

[@NICITACADEMY]

Most welcome. Thank You, Keep watching. Like and share.

[@chithrak8763]

Sir workflow run is taking long time to execute when doing flatfile to table load. What may be the reason.

[@NICITACADEMY]

please check performance tuning technique video in the playlist. I have explained.

[@ShubhamPatil-cu1qo]

2:32:00 table to table

[@csj690]

Look at this : 1:12:01 --> Cost is expensive ??? 1:12:22 --> AI, ML....we will use data warehouse side ???

[@venkateshvenki7552]

Sir actually I'm B Tech EEE background 2018 pass out still I'm not learning any course so which course is better for me like with out programming like Devops or testing and Sql please reply me

[@NICITACADEMY]

Hi, Start learning SQL Day 1 to 10 and then Informatica 10 hours, we have lot of openings in IT for this. Check in naukri with SQL and Informatica

[@venkateshvenki7552]

@@NICITACADEMY thank you so much for replying to me sir, actually which is best in SQL with Power Bi,, and Sql ETL tool sir please

[@haricharangv]

Sir at 2:58:51 the workflow is getting succeeded and I have checked the source/target statistics the core target table is not getting loaded how to fix this i have tried to fix this but couldn't...what could have gone wrong plz help

[@NICITACADEMY]

please check whether you are inserting the data in the table, if yes then commit and execute the Informatica.

[@haricharangv]

@@NICITACADEMY sir the data is not being inserted the applied rows and the affected rows are 0 in the workflow for t_employees

[@jyosthna1037]

@@haricharangv after using 'insert' command use 'commit' then only it will save .

[@lalamaheshkumar]

Dear chandra, How I can take delimited flat file say (,) as a data while loading from flat file . can you pls explain how to implement .( Means the flat file has got ,, as a sperator between fileds example : say eno and ename as 1,,kumar

[@NICITACADEMY]

Ask your source team to use double quotes or ask them to go with different delimiter.

[@sai-kumarsk]

Sir can i learn iics without informatica power center knowledge. Which one i learn on iics or power center. Pls im expecting reply sir

[@NICITACADEMY]

Yes, you can learn without PowerCenter. It is similar to PowerCenter. Please watch my PowerCenter KZbin videos to understand the basics.

[@venkataramanasama3832]

how to map if in target table primary key and foreign key is there

[@harikabhupathi4068]

sir, I was at 2:06:46, u created connection between database and informatica. I was facing issue in creating a repository. I used infa as user id and password & localhost:1521 but my connection is failing. please help me from this i tried system and admin also still my connection is failing. Please help me sir. how to provide a successful connection.

[@NICITACADEMY]

what is the error you are getting? why connection is failed ? is that repository created and pw error.

[@Shahari]

Bro. Did you explained about SCD type 2 and 3?? I didn't find here in 10 hrs. Did you maid videos on them separately or what??

[@NICITACADEMY]

Yes, please check the Informatica playlist.

[@luckyprinceable]

sir is it necessary to join any paid course or this video is enough for making practice and becoming expert and get job??

[@NICITACADEMY]

Live training will have complete tutorial. this 10 hours tutorial is also fine to become ETL developer. Many members learned already and got placed. Please watch and practice fully.

[@luckyprinceable]

thanks a lot sir.

[@surashiva6169]

Any coding s or command s are there in informatica power center course.....

[@NICITACADEMY]

No coding in Informatica, Only SQL queries and ETL mapping.

[@liam.t7830]

Hai sir..did you cover all the topics in this video?

[@akbarraza4489]

Hello Sir, loved the way you took the whole session. I want to learn Matillion ETL tool, do you have any provision of training either paid or free?

[@NICITACADEMY]

Sorry, no. Keep watching my channel.

[@samskar]

Advanced excel and seo lectures are there?

[@karthikgobu279]

hi Can you plz help to locate your documents which you said in your video...am not able to find under description.

[@NICITACADEMY]

🌕 Want to join my Informatica upcoming online batches? Please join in the WhatsApp group for an update chat.whatsapp.com/FOw0rNLr0La2wiqMnxkGWg 🔵 It is Job based - Live online training session 🔵 100% Job assistance, Real time training. 🔵 Resume preparation, Interview preparation supported. 🔵 Project explanation, Mock interviews will be taken. 1. Interview preparation, mock interview taken 2. Low cost training 3. Job Assistance 4. Mentors with 14+ yrs 5. Job Oriented Training 6. Life time video recording access 📌For more details on Timing, Fees, Course Content contact me on WhatsApp 🌕wa.link/m4lat0 (📢📢Trainer: Chandra - A Tableau and Informatica certified Professional) 📌Having 14+ years of IT experience in Banking, Insurance and Retail domain 📌Trained 12000 students in last 7 years 📌Handled corporate and Live training sessions

[@prathoshs8756]

Sir plzzzz make a separate playlist for iics in our project we are about to use informatica iics I don’t know where to start if I start with datawhear house it will take time

[@NICITACADEMY]

sure.

[@Shil_theangrybird]

Sir for a 4yr job exp candidate in IT itself can we get job in IICS informatica? Do u teach real time project? If yes! Could u share the details to reach h out

[@tharungourishetti5695]

Sir, I was facing an issue at 2:04:46, u created a connection between database and Informatica. I was facing issue in creating a repository. I followed the steps same in video user I’d: Infa and password: infa, host: local host:1521 and xe edition but still my connection is failing. Please help me with this. I tried user I’d as system and admin also still and facing the same and connection is failing. Please help and provide me a solution for successful connection.

[@NICITACADEMY]

what is the error you are getting? why connection is failed ? is that repository created and pw error.

[@tharungourishetti5695]

@@NICITACADEMY while I was testing the connection, I was getting a window showing “ The connection failed. Correct the database connection and try again”. And I checked in Informatica installation folder>10.4.1>Informatica_10.4.1_services text document, in that document it is saying “connection refused, the specified service name(xe) was not recognized by Oracle server. Please check this and solve the issue and provide me the procedure to make my connection successful. Please

[@sukanyagutta2515]

Hi Sir,I want to learn informatica and became a ETL developer after watching your videos. I am in US .How are the opportunities in US for ETL developers.Please let me know.Thanks in advance.

[@NICITACADEMY]

Hi, In US we have lot of opening for IICS and Informatica, My US students are getting 100% placed after completing my Live training. Please join my Live informatica or IICS training session For more details contact me on WhatsApp wa.link/m4lat0

[@akshaykadbane9482]

Sometimes using both sql query and source filter condition in source qualifier transformation both doesn't work session succeeds but no expected result....Any reason?

[@NICITACADEMY]

SQL query only execute..

[@akshaykadbane9482]

@@NICITACADEMYThanks for reply sir.. Any reason or mechanism behind it..

[@rohittalreja9143]

Fantastic Video! Got to learn each and every concept in depth! Thankyou So much 👍👍

[@NICITACADEMY]

Glad it was helpful! Keep watching.

[@yashaswinishrigopalan9717]

I am practising your exercises. I have the following doubts 1. Sometimes my workflow fails and when i try to view the session log . Unable to fetch the log- Internal exception occured with message LGS_10052. After sometime once i disconnect and reconnect rep, it works fine without any issues. Why this pbm happens? 2. Whenever i change the mapping and saving it. Do i need to refresh the wf? I dont have that option. I am using informatica 10.2.0

[@RAHULKUMAR-px8em]

Sir where is Dataset which are used in the Video session, I want this dataset for Hands On Practice

[@NICITACADEMY]

please watch my session without skipping, I have explained how to create data set.

[@revanth3068]

Sir while configuring domains i added Domain as Domain and then gateway host as : localhost and then gateway port as 6005..but it's not working

[@janarmp]

Hi Sir, please let me know which video making tool used in 1st few minutes

[@PradeepKanaparthy]

sir, can we resolve this issue: exceeded daily limit of 100 jobs?

[@RAHULKUMAR-px8em]

Sir How to Resolve the Issues When Workflow will be Fail in the Monitor show the Workflow failed

[@chithrak8763]

Sir when trying to do test mapping unable do darg and drop target table getting like Target definition transportation may not be created in a mapplet. How to resolve it

[@NICITACADEMY]

please do it on mapping designer, I hope you are doing it on mapplet designer.

[@chithrak8763]

@@NICITACADEMY yes I am doing in mapplet designer

[@NICITACADEMY]

in mapplet, we can't get Target. I have explained. Do it on Mapping designer.

[@poplikamal27]

Hello Sir, I have one question - Union Transformation act as UNION All Still it's an active transformation. Some says data comes through multiple source or it changes the order of rows. but i am not satisfied with this answer. because as per definition if Transformation changes Number of input rows and number or output rows OR changes row type OR transaction boundary then it's active. Union doesn't satisfy any of these 3 condition.

[@RanjithlL]

Hello sir, is it possible to extract data from external api end point using Informatica. Currently we are using airflow to do ETL process where we are making api calls to different source in the extraction phase. And now we are planning to using Informatica for ETL process. Since we are new to this we now aware of rest api call feature in Informatica. Please can you help us sir. How we can do api call in Informatica.

[@NICITACADEMY]

Yes we can

[@RanjithlL]

Tq sir. Can you take one session for external api call using Informatica

[@NICITACADEMY]

Keep watching my channel.

[@EUK379]

Good Noon Bro ,I downloaded informatica from oracle E delivery file is in form of G01 type and not extracting using winrar and winzip also ,I downloaded win 10 64 bit informatica any solutions bro...

[@NICITACADEMY]

Please check my installation video. And description

[@ashwinipatil1231]

Sir, i have done mtech in cs 2020, i have a carrrrr gap , can i start this course n get job ?

[@raghu9880]

Sir please do a class on ab initio tool

[@harikaramisetty6697]

Hi sir i got problem while creating a domain . Keystore creation has failed . Help me to resolve this sir