Class4 - Informatica Powercenter ETL

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

[@chinukuchappidi1810]

Hii brother.....CASE SENSITIVE OPTION should always be in which condition....is it ON/OFF Condition....

[@siddheshvedre5288]

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

[@vishalchauhan9832]

@@gouthams sir pls start IICS

[@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]

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]

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

[@vishalchauhan9832]

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

[@sunilkoppad4860]

Can you please make video on unix/Linux in etl (Why we use unix/Linux in etl testing and how to use unix/Linux in etl testing )