1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.

Question Posted / jakki


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can impl..

Answer / murthy

yes,there are many examples for this I will give one let's
take expresion using for ltrim and rtim operation,date
conversions etc.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More ETL Interview Questions

I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  

what is Forward,Reverse and Re_engineering?

0 Answers  

Explain what is etl process? How many steps etl contains explain with example?

0 Answers  

what make u disappointmnets in u r career

0 Answers   Infosys,

what is the use of structures?how many nodes can u create in a structure?

0 Answers  




what is SMP AND MPP?

8 Answers  

what happens if the info.server doesn't find the session parameter in the parameter file?

0 Answers  

What do you understand by active and passive transformations?

0 Answers  

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 Answers  

when will use SQL override in a lookup transformation?

0 Answers  

What is etl process. How many steps etl contains explain with example?

0 Answers  

What is meant by incremental load?

0 Answers  

For more ETL Interview Questions Click Here
Categories