Session #8 - Filter Transformation in Informatica PowerCenter | Informatica Training series

Поділитися
Вставка
  • Опубліковано 21 жов 2024
  • #Informatica#informaticatutorial#informaticapowercenter#informaticatransformations
    ========================================================
    🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
    📌Informatica PowerCenter
    github.com/nic...
    📌IICS
    github.com/nic...
    ========================================================
    🌕 If you need self-paced complete Informatica ETL developer training batch recorded sessions - 35 days session(Paid) with all notes, Sample Resumes, interview questions and answers, Day wise exercise and 100 case studies questions (Paid), please write to nicitacademy@gmail.com/ or WhatsApp me @7010080468
    📌 Day wise training session day 1 to 35 complete training, 35 hours
    📌 All the day wise notes, exercises for practice, QA for interview
    📌Resume preparation session - with 6 sample resumes
    📌Roles and responsibilities session
    📌Interview preparation session - Interview QA documents
    📌Complex scenario session
    📌Project architecture session
    📌Interview questions and answers session
    📌Life time access - no need to download
    Please write to nicitacademy@gmail.com/ or WhatsApp me @7010080468
    ========================================================
    🌕 Informatica 10.4 Installation with steps:
    • Informatica Installati...
    **********************************************************************
    🔵Informatica training in TAMIL - Playlist
    • Informatica Training -...
    🌕 Informatica training in ENGLISH - Playlist
    • Informatica Training S...
    🔵Informatica Interview Preparation - TAMIL
    • Informatica Interview ...
    🌕 Informatica Interview Preparation - ENGLISH
    • Informatica Interview ...
    *******************************************************************************
    Join this channel to get access to perks:
    / @nicitacademy
    ********************************************************************************
    In this video, we’ll learn Filter transformation in informatica
    Informatica Filter transformation in tamil
    Filter transformation in tamil
    what is Filter Transformation in informatica
    how to use Filter transformation in informatica
    Different properties in Filter Transformation
    Filter Transformation example
    What is Filter Transformation
    difference between Source Qualifier filter and Filter transformation
    Troubleshoot and Error handling in Informatica
    How to load multiple files in informatica
    Informatica tutorial in tamil
    Flatfile to table load in tamil
    Informatica in Tamil
    Informatica training in Tamil
    How to load data from flat file
    Getting started with Informatica
    Informatica Transformations with Examples
    Informatica Tutorial
    Informatica Training for Biginners
    Gain insight on ETL best practices using Informatica
    Informatica PowerCenter Training
    Informatica Tutorial For Beginners
    Informatica Powercenter Tutorial
    Beginners Complete Informatica Powercenter 9x ETL tutorial
    ETL Training
    Informatica trainging in Tamil
    ETL Informatica training
    Data warehouse training

КОМЕНТАРІ • 26

  • @NICITACADEMY
    @NICITACADEMY  2 роки тому +3

    Complete 48 hours of Self-Paced Courses and Interview Questions Links:*
    courses.nicitacademy.com/
    Are you interested in joining my Live training? or Self-Paced course?

    You can visit our website for more details.
    www.nicitacademy.com/
    Contact me for more details @ 🌕 wa.link/m4lat0
    *WhatsApp group:*
    chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
    Thanks,
    NiC IT Academy
    =======================================================================
    🔵Oracle SQL Tutorial - English
    ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
    📌*IICS demo session:*
    ua-cam.com/video/C1zGVRFM3-A/v-deo.html
    📌*Informatica Full Course:*
    ua-cam.com/video/V2FtZ_INmjg/v-deo.html
    📌*SQL Full Course:*
    ua-cam.com/video/iuvzjf7nU1I/v-deo.html
    📌*Informatica, IICS, and SQL playlist*
    🌕 IICS Tutorial ENGLISH - Playlist
    ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
    🌕 Informatica training in ENGLISH - Playlist
    ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
    🌕 Informatica Interview Preparation - ENGLISH
    ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
    🌕Oracle SQL - தமிழில்
    ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
    🔵 Informatica training in தமிழில் - Playlist
    ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
    🔵 Informatica Interview Preparation - TAMIL
    ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
    🔵Unix for Informatica Developer
    ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
    🌕Informatica Project videos
    ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
    Please subscribe, Like, and comment. I will post more videos.
    Thanks

  • @sujitghorpade1
    @sujitghorpade1 2 роки тому +6

    Only because of you sir I could undestand what is informatica..
    I had very costly coaching but it was meaningless. But u r very nice teacher

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      Thank You very much.

    • @sujitghorpade1
      @sujitghorpade1 2 роки тому +1

      Teaching is an art sir and god has given that gift to you

  • @srinuvasan2050
    @srinuvasan2050 3 роки тому +1

    This is really a most useful channel which produces quality content. Congrats

  • @dineshyadav-iy2wr
    @dineshyadav-iy2wr 2 роки тому +1

    Great Learning and unique Lecture on Informatica.

  • @sonurawat7069
    @sonurawat7069 2 роки тому +1

    very clean and to the point explanation. please make series for informatica ETL testing also

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      Sure I will. I already created 4 hrs session, I am working on the final stage. I will upload soon. Watch playlist. Keep watching my channel.

  • @muzammilpajanigar1251
    @muzammilpajanigar1251 3 роки тому +2

    Very helpful video sir ....
    Plz upload more transformation videos in English also...

  • @naveenandhavarapu9456
    @naveenandhavarapu9456 3 роки тому +3

    Can you make a video on interview questions and answer ,,
    Real time scenario s

  • @shaikabegum8771
    @shaikabegum8771 Рік тому +1

    Hi,
    We can do unit testing for each and every transformations or only expression transformation??
    Please give reply 🙏🙏

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

      not at transformation level, it is source to target level. complete ETL logic.

  • @sekhar5430
    @sekhar5430 2 роки тому +1

    Thank you sir

  • @saurabhranadive787
    @saurabhranadive787 2 роки тому +1

    Sir,
    Why do we need full outer join in joiner transformation..
    Can you plzz explain it with real time example.
    Thanking you😊.

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      We will use Full Outer join to compare two tables data.
      The data is available in first table and not available in second table(null on right side)
      The data is not available in first table and available in second table(null on left side)
      Based on this we will decide some use case.

  • @vishalrana302
    @vishalrana302 2 роки тому +1

    hey can we write SQL query to load data in destination table according this mappings

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      If it is two different data bases, then we can't write.

  • @naliniswaraj4984
    @naliniswaraj4984 2 роки тому +1

    Can we have filter just after scr defination,if yes then how we can write SQ?

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      If source is FF then we can have, otherwise write filter condition in SQ. please watch my session fully. I have explained.

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

    Please help me to create a Relational Connection for SQL Server in Informatica workflow Manager. When I tried to create one, it's stating Database driver error.

  • @subhanivasareddythummapudi3836

    At 10:45, Total records 107, passed records 35 then Rejected should be 107-35 = 72. But Rejected is showing 0 ZERO for both Source and Target. Why.?

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

      It is not rejected, it is filtered. Rejected is different from filtered one.