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.

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

[@vineethguduru199]

Great sir. Add the timestamps. That would help.

[@yuvrajborase558]

Done with 10 hr series, Thanks for such useful content

[@NICITACADEMY]

Nice work!

[@blrshekhar9811]

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

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

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

[@vikaskumar-qr5tj]

Fabulous sir all content at one place♥️

[@NICITACADEMY]

Thanks, Keep watching.

[@jyothikathi7192]

YOUR EXPLANATION IS AWESOME . TQ 👍👍👌👌

[@NICITACADEMY]

Thanks

[@tejateja6523]

Your teaching is excellent sir thank you sir

[@NICITACADEMY]

Thanks 🙏 Keep watching

[@yashaswinishrigopalan9717]

Clear explanation. Thank you so much

[@NICITACADEMY]

You are welcome

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

[@nandhinibhaskar97]

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

[@NICITACADEMY]

You are most welcome

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

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

[@khadarbasha4776]

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

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

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

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

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

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

[@syedkirmani9009]

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

[@sivabala4128]

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

[@NICITACADEMY]

Thanks and welcome. Please like and share my video.

[@mukundam9428]

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

[@NICITACADEMY]

You are welcome!

[@rajlatte9131]

Hello Sir, Thank you very much for the recording, But couldn't see the related files in the description.. Could you please share these files..!!! Thank You

[@saleelasalim9573]

sir even i couldn't find the related files

[@pavandadi9076]

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

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

[@EUK379]

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

[@NICITACADEMY]

Thank you, keep watching my channel.

[@ponnupradeepanee8805]

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

[@NICITACADEMY]

So nice of you

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

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

[@kommanajyothsna7646]

How does Informatica works on non shared filesystem on multiple nodes

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

[@guruguru6472]

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

[@NICITACADEMY]

It's my pleasure

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

[@charishmasingireddy5156]

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

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

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

[@venkataramanasama3832]

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

[@RAHULKUMAR-px8em]

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

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

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

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

[@lynnalhaimy]

Thank you! Great work

[@NICITACADEMY]

Thank you too!

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

[@csj690]

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

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

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

[@mukundam9428]

could you please make one video for fact load , i am very curious to understand how fact load will be done.

[@NICITACADEMY]

Okay, I will do one video on Dimension and Fact table loading

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

[@subbareddyvenkat]

Great session's

[@NICITACADEMY]

Thank You

[@geetakegeet0520]

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

[@electricalproject1920]

Please make videos on informatica MDM

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

[@rajasekhar8261]

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

[@NICITACADEMY]

Sure I will

[@nagarjunreddyk2182]

sir i couldnt see second video in youtube for parameter and variables only 1 session i can see

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

[@vamsi.reddy1100]

One small doubt sir, how to use Unix scripting to execute work flows of informatica. Please make a video if possible..!

[@NICITACADEMY]

Sure I will do.

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

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

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

[@My-Research]

nice video sir

[@NICITACADEMY]

Thanks and welcome

[@rajareddy-rv4vh]

Hi sir good video Plz send class note for informatica sir

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

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

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

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

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

[@ayushkumarsingh5018]

Thanks a lot sir for this tutorial😀

[@NICITACADEMY]

Most welcome 😊

[@PradeepKanaparthy]

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

[@s...2581]

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

[@nixxy1074]

Massive respect for you.

[@NICITACADEMY]

Thank you very much

[@janarmp]

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

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

[@samskar]

Advanced excel and seo lectures are there?

[@harikaramisetty6697]

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

[@gomathivelayutham]

Hi can you please give simple explanation to understand the difference between Datawarehouse and Enterprise datawarehouse.

[@NICITACADEMY]

Both are same. Edw is commercial data warehouse for enterprise level

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

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

[@MsPradeepchowdary]

Thank you sir many people who cannot afford the course with money...your video helps a lot 🙏

[@NICITACADEMY]

So nice of you

[@andreamaiellaro6581]

Hi, i am wondering what version of Powercenter is all about....

[@NICITACADEMY]

10.4

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

[@sivagarisravan5449]

how did you created employees_countries table in hr source

[@NICITACADEMY]

Kindly watch my Oracle Day 2 session and create this table

[@sivagarisravan5449]

@@NICITACADEMY unable to create country data

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

[@liam.t7830]

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

[@karunakarreddy966]

Hi, can you please create videos on IICS

[@NICITACADEMY]

Sure I will do.

[@gopimanchala161]

hi sir why you are not upload infomatica total course in UDEMY sir

[@NICITACADEMY]

Need to upload, Couldn't spend more time.

[@koyaguramahesh5826]

Thanks for tutorial sir, I'm facing problem with an error as" -Failed to create the powerCenter Repository Services,-Failed to enable the powercenter repository services''.Installation was completed but status was error.Can you please help me out from this error sir?

[@NICITACADEMY]

yeah, You can create repository and integration service in the admin console.

[@harithai8658]

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

[@NICITACADEMY]

You're most welcome

[@sivaranjanis8605]

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

[@NICITACADEMY]

Most welcome!

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

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

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

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

[@sureshgomathinayagam9124]

Will it be useful for testers who use informatica or restricted to developers only ? Please let us know

[@NICITACADEMY]

Yes definitely.

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

[@RAHULKUMAR-px8em]

sir pls Help me I geting Error in all the workflow Severity Timestamp Node Thread Message Code Message ERROR 19-01-2023 12:14:59 node01 PRE-SESS CMN_1022 Database driver error... CMN_1022 [ Database driver error... Function Name : Logon ORA-24324: service handle not initialized Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [core] and connection string [xe].] How to resolve it sir

[@RAHULKUMAR-px8em]

Severity Timestamp Node Thread Message Code Message ERROR 19-01-2023 13:37:04 node01 PRE-SESS WRT_8233 Unable to get Truncate Connection Object from target [Relational Writer]

[@ikjotsingh9]

Hi Sir , while installing informatica server getting error as keystore creation failed. please assist what needs to be done

[@NICITACADEMY]

Please uninstall the server, and have Oracle 11g as database, reinstall it one more time. Please check my pinned comments