Goutham
Goutham
  • 19
  • 67 096
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
Переглядів: 649

Відео

Class17 - Informatica Powercenter ETL
Переглядів 2,2 тис.Рік тому
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 тис.Рік тому
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 тис.Рік тому
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 тис.Рік тому
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
Переглядів 1,9 тис.Рік тому
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,4 тис.Рік тому
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,7 тис.Рік тому
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,2 тис.Рік тому
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,4 тис.Рік тому
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,5 тис.Рік тому
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,5 тис.Рік тому
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 тис.Рік тому
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,5 тис.Рік тому
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,1 тис.Рік тому
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
Class3 - Informatica Powercenter ETL
Переглядів 4 тис.Рік тому
Class3 - Informatica Powercenter ETL
Class2 - Informatica Powercenter ETL
Переглядів 8 тис.Рік тому
Class2 - Informatica Powercenter ETL
Class1 - Informatica Powercenter ETL
Переглядів 18 тис.Рік тому
Class1 - Informatica Powercenter ETL
ORACLE SQL - BASIC HOW TO's?
Переглядів 816Рік тому
ORACLE SQL - BASIC HOW TO's?

КОМЕНТАРІ

  • @PriyanshMangal
    @PriyanshMangal 22 дні тому

    Helpful session brother 👍

  • @jannurajkamal539
    @jannurajkamal539 2 місяці тому

    Hi gowtham can you please share notes ?

  • @srikanthsuddala613
    @srikanthsuddala613 4 місяці тому

    Hi, are you going to post new videos anytime soon ??

  • @gigarbazzz
    @gigarbazzz 5 місяців тому

    How to join your new batch

  • @sethu14
    @sethu14 5 місяців тому

    the series was amazing, and easy to understand.

  • @JiJishorts
    @JiJishorts 7 місяців тому

    Please upload next concepts videos.. these are really useful and the only videos I find helpful for getting better understanding of Informatica..

  • @sahilkhurana7923
    @sahilkhurana7923 9 місяців тому

    Nice explanation sir ji ❤

  • @atlanticoceanvoyagebird2630
    @atlanticoceanvoyagebird2630 9 місяців тому

    Great Tips for Interview. Thanks.

  • @atlanticoceanvoyagebird2630
    @atlanticoceanvoyagebird2630 9 місяців тому

    The best Teacher across the world. Muhammad from North America.

  • @atlanticoceanvoyagebird2630
    @atlanticoceanvoyagebird2630 10 місяців тому

    AN UNIMAGINATIVE TEACHING TECHNIQUES THAT I COULD NOT FIND ON THE INTERNET. YOU ARE ONLY INCREDIBLE TEACHER. MUHAMMAD FROM NORTH AMERICA

  • @Sampath439
    @Sampath439 10 місяців тому

    hi i am waiting for your videos please share with us it's very use full videos and simply understanding concepts

  • @RupaliDawkore
    @RupaliDawkore 10 місяців тому

    how to install this informatica tool so that i can also do hands on practice please suggest

  • @ochos47
    @ochos47 11 місяців тому

    Can be a problem if i hace null un my data?

  • @balamsomusundar2578
    @balamsomusundar2578 Рік тому

    CAN WE GIVE MULTIPLE CONDITIONS IN LOOKUP CONDITIONS

  • @pratikshabansode-q5o
    @pratikshabansode-q5o Рік тому

    please tell which Application is required for informatica practical lab

  • @Mohamed-qt4vc
    @Mohamed-qt4vc Рік тому

    Hello! Why did you stop the series? it was really helpful and the way you explain is very good! i hope you continue it :)

  • @zUNSKILLED
    @zUNSKILLED Рік тому

    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 ?

  • @Mohamed-qt4vc
    @Mohamed-qt4vc Рік тому

    Thanks for the amazing explanation Goutham! would you mind uploading the sample databases(SRCDB, STGDB, TGTDB), please?

  • @ASHISHKENDRE
    @ASHISHKENDRE Рік тому

    Sir your way of teaching is very easy to understand,please upload the remaining part of the course. Thanks in advance

  • @Beast-ur3ew
    @Beast-ur3ew Рік тому

    This is the work we do in real time also?

  • @rajyalakshmi418
    @rajyalakshmi418 Рік тому

    The way of your explanation is too good sir can you please help us to upgrade skills please sir

  • @rajyalakshmi418
    @rajyalakshmi418 Рік тому

    Keep on posting videos

  • @rajyalakshmi418
    @rajyalakshmi418 Рік тому

    Hii sir Good Evening

  • @pramodgadekar3081
    @pramodgadekar3081 Рік тому

    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 ❤

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    Could you pls add IICS tutorial as well ?

  • @ganeshnaik5365
    @ganeshnaik5365 Рік тому

    awesome sir expalination sir......i watched all videos

  • @ganeshnaik5365
    @ganeshnaik5365 Рік тому

    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

  • @ganeshnaik5365
    @ganeshnaik5365 Рік тому

    thank u for explain update strategy sir. I have one doubt. can we do update,insert,delete for flatfiles ?

  • @ganeshnaik5365
    @ganeshnaik5365 Рік тому

    bro I did same means start work flow our job is succeded but records are not added to target table why ? can u explain

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    One of the best explanation on Joins and Join transformation. Very helpful video . Highly recommended !

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    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 " ?

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    Mater Outer Join, Detail outer join are right , left joins right sir ?

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    Sir when we will send sorter data then Informatica will already sense it before transformation process ?

  • @AmitRaj-zb9vi
    @AmitRaj-zb9vi Рік тому

    Thankyou so much sir this series has helped me alot understanding and learning informatica power center

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    Excellent explanation !

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    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 .

    • @sahilkhurana7923
      @sahilkhurana7923 9 місяців тому

      Sir have you find out any alternate option??

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    Sir, what is Tracing level " Normal " just below to Filter condition ?

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    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 ?

    • @avinashmupparaju7725
      @avinashmupparaju7725 Рік тому

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

    • @sahilkhurana7923
      @sahilkhurana7923 9 місяців тому

      Sir I believe internally informatica is taking all the attributes for checking distinct records

    • @vishalchauhan9832
      @vishalchauhan9832 9 місяців тому

      @@sahilkhurana7923 acha 12 lpa pakka hai apka sir ji .

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    Very helpful !

  • @vishalchauhan9832
    @vishalchauhan9832 Рік тому

    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 .

  • @pritampatil473
    @pritampatil473 Рік тому

    can u plz provide text file that shown in every videos ?

  • @siddheshvedre5288
    @siddheshvedre5288 Рік тому

    Sir Your voice is like Sachin Tendulkar 😂 but best INFORMATICA POWERCENTER Tutorial sir🎉❤

  • @ramaRao-u4r
    @ramaRao-u4r Рік тому

    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

  • @techkj9876
    @techkj9876 Рік тому

    Here we select both cycle and Reset option what will happened bro

  • @anupshastry5969
    @anupshastry5969 Рік тому

    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?

    • @smirthi3693
      @smirthi3693 Рік тому

      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.

    • @vishalchauhan9832
      @vishalchauhan9832 Рік тому

      @@smirthi3693 Are u able to download Informatica Powercentre ?

  • @anupshastry5969
    @anupshastry5969 Рік тому

    before performing mapping and load to target from source should we have to make sure in oracle that target has no rows

  • @avugaddiashok2058
    @avugaddiashok2058 Рік тому

    Add keywords to your Title bro so it will help in getting views. Your are having good content try that change.

  • @amityadav-tu4hc
    @amityadav-tu4hc Рік тому

    This is Amazing series on Informatica that I found in UA-cam , really very helpful.

  • @amityadav-tu4hc
    @amityadav-tu4hc Рік тому

    Sir if , Possible pls provide good level of Project on Informatica

  • @shreyassakriofficial
    @shreyassakriofficial Рік тому

    Sir please upload remaining videos too. I am finding this playlist interesting and would like to study completely from you