Goutham
Goutham
  • 19
  • 70 513
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
มุมมอง: 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
Class3 - Informatica Powercenter ETL
มุมมอง 4.2K2 ปีที่แล้ว
Class3 - Informatica Powercenter ETL
Class2 - Informatica Powercenter ETL
มุมมอง 9K2 ปีที่แล้ว
Class2 - Informatica Powercenter ETL
Class1 - Informatica Powercenter ETL
มุมมอง 19K2 ปีที่แล้ว
Class1 - Informatica Powercenter ETL
ORACLE SQL - BASIC HOW TO's?
มุมมอง 8252 ปีที่แล้ว
ORACLE SQL - BASIC HOW TO's?

ความคิดเห็น

  • @Jayansh0522
    @Jayansh0522 หลายเดือนก่อน

    Best explanation ❤

  • @PriyanshMangal
    @PriyanshMangal 2 หลายเดือนก่อน

    Helpful session brother 👍

  • @jannurajkamal539
    @jannurajkamal539 4 หลายเดือนก่อน

    Hi gowtham can you please share notes ?

  • @srikanthsuddala613
    @srikanthsuddala613 6 หลายเดือนก่อน

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

  • @gigarbazzz
    @gigarbazzz 7 หลายเดือนก่อน

    How to join your new batch

  • @sethu14
    @sethu14 7 หลายเดือนก่อน

    the series was amazing, and easy to understand.

  • @JiJishorts
    @JiJishorts 9 หลายเดือนก่อน

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

  • @sahilkhurana7923
    @sahilkhurana7923 11 หลายเดือนก่อน

    Nice explanation sir ji ❤

  • @atlanticoceanvoyagebird2630
    @atlanticoceanvoyagebird2630 11 หลายเดือนก่อน

    Great Tips for Interview. Thanks.

  • @atlanticoceanvoyagebird2630
    @atlanticoceanvoyagebird2630 11 หลายเดือนก่อน

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

  • @atlanticoceanvoyagebird2630
    @atlanticoceanvoyagebird2630 11 หลายเดือนก่อน

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

  • @Sampath439
    @Sampath439 ปีที่แล้ว

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

  • @RupaliDawkore
    @RupaliDawkore ปีที่แล้ว

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

  • @ochos47
    @ochos47 ปีที่แล้ว

    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 11 หลายเดือนก่อน

      Sir have you find out any alternate option??

  • @vishalchauhan9832
    @vishalchauhan9832 ปีที่แล้ว

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

    • @vishalchauhan9832
      @vishalchauhan9832 ปีที่แล้ว

      @@gouthams Thank you so much sir. These lectures are too good. 🙂😊

    • @vishalchauhan9832
      @vishalchauhan9832 ปีที่แล้ว

      @@gouthams Thank you sir ji !

  • @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 11 หลายเดือนก่อน

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

    • @vishalchauhan9832
      @vishalchauhan9832 11 หลายเดือนก่อน

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

  • @vishalchauhan9832
    @vishalchauhan9832 ปีที่แล้ว

    Very helpful !

    • @sahilkhurana7923
      @sahilkhurana7923 ปีที่แล้ว

      Thanks sir for sharing this helpful video with me ❤

    • @vishalchauhan9832
      @vishalchauhan9832 ปีที่แล้ว

      @@sahilkhurana7923 😁🙏

  • @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 TH-cam , really very helpful.

  • @amityadav-tu4hc
    @amityadav-tu4hc ปีที่แล้ว

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