Informatica is a very powerful ETL tool created by Informatica Corp. This tool allows the miners to actually do transformations on the data and load it into the data warehouse for further analysis. Informatica creates the following output files – Informatica Server Log – This file creates the log for all the status and error Continue reading

Informatica is a ETL tool and you need to have the source data on which you can perform the ETL process. Now, this source can be either flat file or a SQL file. But with flat file there are some issues. Let us have a look at some of them. Also, if you are preparing Continue reading

Informatica allows you to rank the columns according to a certain condition. But remember, you can either rank then in increasing order or decreasing. It is different from average and maximum functions in such that it allows you to select a range of numbers instead of one. So, like you can find out the top Continue reading

Often when learning Informatica, you are told that once you create the table in the Target Analyzer you need to go to the Target tab and generate and execute the SQL. But do you know why are you doing it?? I mean you have created the table in Informatica and so you will be able Continue reading