IT Pandora (ETL,DB,UNIX,AWS,NodeJS,Github etc.)

One of the most common used transformation in Informatica is Expression transformation. In Expression transformation we can perform various operations such as data conversions i.e to_date,to_char, string manipulation such as substr,instr etc. Now coming to one of the widely and prominent task which we perform using Expression transformation is looping a value. Expression transformation has three types of ports i.e. input,variable and output.Only output port values can be propagated to next transformations. So in order to pass values of input and variable ports to next level of transformation these must be assigned to output ports.The order of execution in Expression transformation is top to bottom and first input then variable and finally output ports are processed. let us consider the following scenario   The files should be generated with employee name as file name and that particular file should have the details of that respective employee only, if the employee has more t...

One of the most important concept  in Data ware housing. SCD Type II  means history of data should be saved.In here we can use status flags,dates and versioning to store the data. Consider the following example So during the first run on jan 1 2015 we got the data as A1B2 and 12345. And on jan 5 2015 we got the data as A1B2 and 56789. So as part of SCD type II we need to maintain history hence the latest record should be inserted and earlier record should be updated. In order to identify the latest record we have columns namely status,startdate,enddate The latest record will have status have ÁCT and End Date will be a high end date (12/31/9999).Job_id is the primary key In informatica for implementing SCD type II the mapping will look in the following way So in here we have transformation such as aggregator,lookup,expression,router and update Aggregator transformation is used to remove any duplicates coming from source. We create lookup on the ...