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

#Informatica#informaticatutorial#informaticapowercenter#informaticatransformations

In this video we will learn informatica tutorial, informatica etl tutorial, informatica video tutorials, informatica etl, informatica dashboard tutorial, informatica powercenter tutorial, informatica training, informatica tutorial for beginners
===========================================================================

📢Dear Techies,

Do you want to join Informatica, IICS Interview preparation, job search Group?

🔵Please join in the WhatsApp group for an update

🌕For Live training contact me on WhatsApp [phone]) or below link

🔵 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. Have 14+ yrs of IT Exp
5. Job Oriented Training
6. Life time video recording access

(📢📢Trainer: Chandra - A Tableau and Informatica certified Professional)
📌Having 14+ years of IT experience in Banking, Insurance and Retail domain
📌Taking Training last 8+ years
📌Handled corporate and Live training sessions
========================================================

🌕IICS or Informatica Self paced Recorded videos

If you need complete 🌕Informatica PowerCenter or 🌕IICS Cloud ETL developer training batch recorded sessions - 35 days session(Paid) with all notes, Sample Resumes, interview questions and answers, Day wise exercises and answers, 100 case studies questions.

📌Day wise training session day 1 to 35 complete training
📌Complete Notes and Material
📌Real time project architecture
📌Daily exercise
📌Resume preparation session(with 6 realtime resumes)
📌IICS developer Roles and responsibility session
📌Interview preparation session
📌Complex scenario session
📌Project architecture session
📌Interview questions and answers session
📌Complete CDI and Basics on CAI sessions

Recoding will be shared via Google drive link - Life time access, materials downloadable. videos are not downloadable.

Kindly Ping me directly on WhatsApp for Price and If you need course content or further details contact me on WhatsApp

Most of the students are getting placed with good package with this self paced course. Please hurry-up.

Thanks
(📢📢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 8 years
📌Handled corporate and Live training sessions

========================================================
Chapters:
========

0:00 Introduction
1:42 What is Business Intelligence
56:15 Dimension and fact table in data warehouse
1:20:39 What is Data model
1:24:27 OLAP Cube
1:32:12 Informatica Architecture
2:26:32 Informatica PowerCenter Client Components
2:47:05 Flat File to Table Load in Informatica
2:59:28 Table to Flat File Load in Informatica
3:10:11 Active and Passive Transformation in Informatica
3:14:10 Source Qualifier Transformation in Informatica
3:58:51 Filter Transformation in Informatica
4:12:07 Expression Transformation in Informatica
4:44:26 Joiner Transformation in Informatica
4:58:43 Sorter Transformation in Informatica
5:18:15 Aggregator Transformation in Informatica
5:40:34 Router Transformation in informatica
6:02:59 Rank Transformation in Infromatica
6:15:53 Sequence generator transformation in informatica
6:30:48 Union Transformation transformation in informatica
6:41:45 Lookup Transformation transformation in informatica
6:42:49 connected lookup transformation in informatica
6:57:58 unconnected lookup transformation in informatica
7:08:48 How to return Multiple return port in unconnected lookup
7:19:57 Lookup policy on multiple match
7:41:24 Update strategy transformation
8:06:18 Java Transformation
8:21:23 Parameter and Variables
8:36:39 Debugger in informatica
8:50:42 Performance Tuning in informatica
9:28:41 Slowly changing dimension - SCD types in informatica

========================================================
🌕 Informatica 10.4 Installation with steps:

**********************************************************************
🌕 Informatica training in ENGLISH - Playlist

🔵 Informatica training in TAMIL - Playlist

🌕 Informatica Interview Preparation - ENGLISH

**********************************

Audio track credit:
Believe Music

[NICITACADEMY]

🌐 *Register IICS/IDMC/Cloud - Self-Paced Courses and Interview Questions Links:*

🌐 *Are you interested in joining my Live training? or Self-Paced course?*

✅ *WhatsApp Group for Informatica technical discussion*

☎Contact us for more details
Direct call & WhatsApp: [phone]

*Oracle SQL Playlist*

*Informatica PowerCenter Playlist*

*Informatica IICS Playlist*

*Oracle PLSQL Playlist*

*Microsoft Azure Playlist*

*Oracle SQL - தமிழில்*

*Informatica PowerCenter - தமிழில்*

Thanks,
NiC IT Academy

[chiruchowdary]

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

[saivasepalli]

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.

[pavandadi]

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

[vineethguduru]

Great sir. Add the timestamps. That would help.

[yuvrajborase]

Done with 10 hr series, Thanks for such useful content

[tharungourishetti]

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.

[blrshekhar]

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

[harikabhupathi]

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.

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

[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

[sushmatetali]

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.

[phanikumar]

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

[RAHULKUMAR-pxem]

sir pls Help me I geting Error in all the workflow




Code Message
ERROR 19-01-2023 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

[Basva]

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

[NasUlaz]

Hi, in workflow manager, if i go to Connections -> Relational I do not see PostgresSQL as an object or type when I want to create that kind of connection? What do you recommend then?

[phaneendrareddy]

Hi, happy to see the full course here so before starting to learn informatica powercenter is there any prerequisites to learn or is it sufficient to start carrer in etl

[khadarbasha]

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

[syedkirmani]

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

[charishmasingireddy]

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