- 19
- 70 513
Goutham
เข้าร่วมเมื่อ 21 ต.ค. 2022
Class18 - Informatica Powercenter ETL
TOPIC DISCUSSED
SCD TYPE 2 IMPLEMENTATION
IT MAINTAINS HISTORICAL VERSION OF THE RECORDS
THIS CAN BE IMPLEMENTED IN 2 WAYS:
BY USING
1. FLAGS
2. DATES
3. VERSIONING
SCD TYPE 2 IMPLEMENTATION
IT MAINTAINS HISTORICAL VERSION OF THE RECORDS
THIS CAN BE IMPLEMENTED IN 2 WAYS:
BY USING
1. FLAGS
2. DATES
3. VERSIONING
มุมมอง: 672
วีดีโอ
Class17 - Informatica Powercenter ETL
มุมมอง 2.3Kปีที่แล้ว
TOPIC DISCUSSED SCD TYPE 1 IMPLEMENTATION USING MD5 Function MD5() - IT HELPS US TO GENERATE HEXADECIMAL VALUE(ALPHA NUMERICAL VALUE) SCD TYPE 1 - IT MAINTAINS ONLY CURRENT VERSION OF THE RECORDS CASE 1: INSERT - NEW RECORD CASE 2: UPDATE - OLD RECORD WITH CHANGES
Class16 - Informatica Powercenter ETL
มุมมอง 2.2Kปีที่แล้ว
TOPIC DISCUSSED SCD TYPE 1 IMPLEMENTATION IT MAINTAINS ONLY CURRENT VERSION OF THE RECORDS CASE 1: INSERT - NEW RECORD CASE 2: UPDATE - OLD RECORD WITH CHANGES
Class15 - Informatica Powercenter ETL
มุมมอง 2.1K2 ปีที่แล้ว
TOPIC DISCUSSED SCD'S - SLOWLY CHANGING DIMENSIONS 1. SCD TYPE 1 - IT MAINTAINS CURRENT VERSION OF THE RECORDS 2. SCD TYPE 2 - IT MAINTAINS HISTORY(ALL VERSIONS OF THE RECORDS ARE MAINTAINED) 3. SCD TYPE 3 - IT MAINTAINS CURRENT VERSION OF THE RECORD AS WELL AS ONE PREVIOUS VERSION OF THE RECORD
Class14 - Informatica Powercenter ETL
มุมมอง 2.1K2 ปีที่แล้ว
TOPIC DISCUSSED NORMALIZER TRANSFORMATION 1. ACTIVE TRANSFORMATION AND CONNECTED 2. USED TO TRANSFORM SINGLE INCOMING ROW INTO MULTIPLE OUTPUT ROWS OR USED TO CONVERT COLUMN INTO ROWS 3. INFORMATICA WILL GENERATE TWO COLUMNS IN MRN TRANS 1. GKID - GENERATED KEY IDENTIFICATION USED TO GENERATE SEQUENCE OF ID'S 2. GCID - GENERATED COLUMN IDENTIFICATION USED TO GENERATE COLUMN ID (REPEATS THE SEQU...
Class13 - Informatica Powercenter ETL
มุมมอง 2K2 ปีที่แล้ว
TOPIC DISCUSSED RANK TRANSFORMATION 1. ACTIVE TRANSFORMATION AND CONNECTED 2. USED TO ASSIGN RANKS BASED UPON A CONDITION IQ- WHAT IS THE BEHAVIOUR OF RANK TRANSFORMATION IN INFORMATICA WETHER IT WILL WORK LIKE RANKS OR DENSE RANK ? IT WORKS SIMILAR TO RANK FUNCTION IN ORACLE NOTE: THE DEFAULT WHICH WILL BE GENERATED BY INFORMATICA WHEN WE CREATE RANK TRANSFORMATION IS RANK INDEX WHICH WILL HEL...
Class12 - Informatica Powercenter ETL
มุมมอง 2.5K2 ปีที่แล้ว
TOPIC'S DISCUSSED UPDATE STRATEGY TRANSFORMATION 1. ACTIVE TRANSFORMATION AND CONNECTED 2. USED TO PERFORM 4 ACTIONS A. INSERT 0 DD_INSERT B. UPDATE 1 DD_UPDATE C. DELETE 2 DD_DELETE D. REJECT 3 DD_REJECT 3. TREAT SOURCE ROWS AS(OPTION IN SESSION PROPERTIES) - WILL BE AUTOMATICALLY SET TO DATA DRIVEN WHEN EVER OUR MAPPING CONTAINS UPDATE STRATEGY TRANSFORMATION INTEGRATION SERVICE WILL BE PERFO...
Class11 - Informatica Powercenter ETL
มุมมอง 2.8K2 ปีที่แล้ว
TOPIC DISCUSSED LOOKUP TRANSFORMATION 1. PASSIVE TRANSFORMATION 2. TYPES OF LOOKUP TRANSFORMATIONS A. CONNECTED LOOKUP B. UNCONNECTED LOOKUP 3. TO GET RELATED VALUES BASED UPON LOOKUP CONDITION 4. LOOKUP ACTS AS A LEFT OUTER JOIN 5. LOOKUP POLICY ON MULTIPLE MATCH A.USE FIRST VALUE B.USE SECOND VALUE C.REPORT A ERROR D. USE ANY VALUE (DEFAULT) 6. WE CAN MAKE A LOOKUP TRANSFORMATION AS ACTIVE TR...
Class10 - Informatica Powercenter ETL
มุมมอง 2.4K2 ปีที่แล้ว
TOPIC'S DISCUSSED JOINER TRANSFORMATION 1. ACTIVE TRANSFORMATION AND CONNECTED 2. USED TO JOIN MULITPLE HETEROGENOUS SOURCE IT SHOULD HAVE ONE COMMON COLUMN INORDER TO PERFORM JOIN 3. TYPES OF JOINS A. NORMAL JOIN (DEFAULT) B. MASTER OUTER JOIN C. DETAIL OUTER JOIN D. FULL OUTER JOIN NORMAL JOIN: MATCHED RECORDS FROM BOTH THE TABLES MASTER OUTER JOIN: MATCHED RECORDS FROM BOTH THE TABLES(NORMAL...
Class9 - Informatica Powercenter ETL
มุมมอง 2.5K2 ปีที่แล้ว
TOPICS DISCUSSED AGGREGATOR TRANSFORMATION 1. ACTIVE TRANSFORMATION AND CONNECTED 2. USED TO GROUP THE DATA AND PERFORM AGGREGATED CALCULATIONS EX: SUM,MAX,MIN,COUNT,AVG 3. IS ALSO USED TO REMOVE DUPLICATES 4. DEFAULT BEHAVIOUR WHEN YOU DONT USE ANY GROUP BY PORT IN AGG TRANSFORMATION IT WILL CONSIDER ALL THE RECORDS AS ONE SINGLE GROUP AND LOAD THE LAST RECORD INTO TARGET TABLE PERFORMANCE POI...
Class8 - Informatica Powercenter ETL
มุมมอง 2.7K2 ปีที่แล้ว
TOPIC'S DISCUSSED SEQUENCE GENERATOR TRANSFORMATION 1. PASSIVE TRANSFORMATION AND CONNECTED 2. USED TO GENERATE SEQUENCE OF ID'S, CYCLIC NUMBERS AND INTERVALS. 3. DEFAULT PORTS - NEXTVAL AND CURRVAL 4. IN REALTIME WE WILL BE USING THIS TRANSFORMATION WHEN WE ARE WORKING WITH SLOWLY CHANGING DIMENSIONS (SCD TYPE 2) IMPLEMENTATIONS. OPTIONS: 1. RESET 2. CYCLE
Class7 - Informatica Powercenter ETL
มุมมอง 2.7K2 ปีที่แล้ว
TOPIC'S DISCUSSED UNION TRANSFORMATION 1. IT'S A ACTIVE TRANSFORMATION AND CONNECTED 2. IS USED MERGE THE RECORDS BETWEEN MULTIPLE HETEROGENOUS SOURCES 3. UNION TRANSFORMATION IS MULTIPLE INPUT AND SINGLE OUTPUT 4. UNION TRANSFORMATION WORKS JUST LIKE UNION ALL IN ORACLE SQL.
Class6 - Informatica Powercenter ETL
มุมมอง 3.2K2 ปีที่แล้ว
TOPIC'S Discussed ROUTER TRANSFORMATION 1. ACTIVE TRANSFORMATION AND CONNECTED 2. WE CAN PASS MULITPLE CONDITIONS 3. WE CAN CAPTURE THE RECORDS WHICH DOESNT SATISFY THE ANY OF THE CONDITIONS SPECIFIED IN THE ROUTER TRASNFORMATION 4. SINGLE INPUT AND MULTIPLE OUTPUT FILTER TRANSFORMATION 1. WE CAN PASS ONLY ONE SINGLE CONDITION 2. WE CANT ABLE TO CAPTURE THE RECORDS WHICH DOESNT SATISFY THE COND...
Class5 - Informatica Powercenter ETL
มุมมอง 3.6K2 ปีที่แล้ว
TOPIC'S DISCUSSED FILTER TRANSFORMATION 1. IT'S AN ACTIVE TRANSFOMRATION AND CONNECTED 2. USED TO FILTER DATA BASED UPON A CONDITION 3. 3 TYPES OF FILTER CONDITIONS WE CAN SPECIFY A. TRUE(DEFAULT) IT ALLOWS ALL THE RECORDS B. FALSE IT DROPS ALL THE RECORDS C. USER DEFINED CONDITIONS EX: DEPTID=10 4. COMPLEX CONDITION EX:IIF ETC *NOTE:CAN WE MAKE FILTER TRANSFOMRATION AS A PASSIVE TRANSFORMATION...
Class4 - Informatica Powercenter ETL
มุมมอง 4.3K2 ปีที่แล้ว
TOPIC'S DISCUSSED SORTER TRANSFORMATION 1. ACTIVE TRANSFORMATION AND CONNECTED 2. IT IS USED TO SORT THE DATA EITHER IN ASCENDING OR DESCENDING 3. IS ALSO USED TO REMOVE DUPLICATES 4. SUPPORTS CASE-SENSITIVE SORTING
Best explanation ❤
Helpful session brother 👍
Hi gowtham can you please share notes ?
Hi, are you going to post new videos anytime soon ??
How to join your new batch
the series was amazing, and easy to understand.
Please upload next concepts videos.. these are really useful and the only videos I find helpful for getting better understanding of Informatica..
Nice explanation sir ji ❤
Great Tips for Interview. Thanks.
The best Teacher across the world. Muhammad from North America.
AN UNIMAGINATIVE TEACHING TECHNIQUES THAT I COULD NOT FIND ON THE INTERNET. YOU ARE ONLY INCREDIBLE TEACHER. MUHAMMAD FROM NORTH AMERICA
hi i am waiting for your videos please share with us it's very use full videos and simply understanding concepts
how to install this informatica tool so that i can also do hands on practice please suggest
Can be a problem if i hace null un my data?
CAN WE GIVE MULTIPLE CONDITIONS IN LOOKUP CONDITIONS
please tell which Application is required for informatica practical lab
Hello! Why did you stop the series? it was really helpful and the way you explain is very good! i hope you continue it :)
Is there a way to let Informatica create the target table structure (copying it from the source structure) instead of pre-creating it as in SSIS ?
Thanks for the amazing explanation Goutham! would you mind uploading the sample databases(SRCDB, STGDB, TGTDB), please?
Sir your way of teaching is very easy to understand,please upload the remaining part of the course. Thanks in advance
This is the work we do in real time also?
The way of your explanation is too good sir can you please help us to upgrade skills please sir
Keep on posting videos
Hii sir Good Evening
Hi Goutham , Your videos and content are awesome. Please upload more videos on informatica like SCD type 2, mapping parameters and variables variables , incremental load, different tasks in workflow etc . Also one request please mentioned the title for each videos. Thanks in advance ❤
Could you pls add IICS tutorial as well ?
awesome sir expalination sir......i watched all videos
I am getting error why .I tried many times but same error repeated.What is the reason my I know Severity Timestamp Node Thread Message Code Message ERROR 10-06-2023 15:27:50 node01 WRITER_1_*_1 WRT_8116 ERROR: Target table [UP_ST_STUDENT_TGT] has no keys specified Row # [0] in bad file
thank u for explain update strategy sir. I have one doubt. can we do update,insert,delete for flatfiles ?
bro I did same means start work flow our job is succeded but records are not added to target table why ? can u explain
One of the best explanation on Joins and Join transformation. Very helpful video . Highly recommended !
Sir we will get a option to choose any table as "MASTER" , DETAIL in Joiner properties OR the table coloumn which we mapped first with joiner transformation activity will automatically consider it " DETAIL " and second source as " MASTER " ?
Mater Outer Join, Detail outer join are right , left joins right sir ?
Sir when we will send sorter data then Informatica will already sense it before transformation process ?
Thankyou so much sir this series has helped me alot understanding and learning informatica power center
Excellent explanation !
Sir is there any alternate way of defining target strcuture for Flat file ? It will be very difficult if we will have more number of columns .
Sir have you find out any alternate option??
Sir, what is Tracing level " Normal " just below to Filter condition ?
@@gouthams Thank you so much sir. These lectures are too good. 🙂😊
@@gouthams Thank you sir ji !
Sir, sorting condition was based on EMP ID , Distinct was also checked for same attribute , right ? so why Informatica is considering even First name Case sensitivity. It should simply look distinct emp_id ? or Distinct is applicable for every attributes ?
Yes I agree with @vishalchauhan9832 statement since we are sorting the data based on EMPID how come the case sensitive logic matters for EMPNAME..! @Goutham please explain..
Sir I believe internally informatica is taking all the attributes for checking distinct records
@@sahilkhurana7923 acha 12 lpa pakka hai apka sir ji .
Very helpful !
Thanks sir for sharing this helpful video with me ❤
@@sahilkhurana7923 😁🙏
Sir , is it necessary to import target structure ? if this is the case then we need to create source structure in target database as well .
can u plz provide text file that shown in every videos ?
+1
Sir Your voice is like Sachin Tendulkar 😂 but best INFORMATICA POWERCENTER Tutorial sir🎉❤
@@gouthams sir pls start IICS
Do we need to change depart ID column based on the join?, DEPT_ID column as null value when you used detail outer join. since dept_ID column was selected from master table
Here we select both cycle and Reset option what will happened bro
sir i have doubt like we are giving two condition in filter transformation also using iff(deptid=10 and deptsal>50000) but you are telling only single condition in possible in filter transformation please answer this question?
By using filter transformation, u can load into only 1 target. But by using router, u can load in to any number of targets based on different conditions. In the above example, based on 3 conditions, data is loaded into 3 different targets.
@@smirthi3693 Are u able to download Informatica Powercentre ?
before performing mapping and load to target from source should we have to make sure in oracle that target has no rows
Add keywords to your Title bro so it will help in getting views. Your are having good content try that change.
This is Amazing series on Informatica that I found in TH-cam , really very helpful.
Sir if , Possible pls provide good level of Project on Informatica