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



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

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  


what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

2 Answers   IBM, Tech Mahindra,


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

0 Answers  


What is the difference between round-robin partitioning and hash partitioning?

0 Answers  


Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  






how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  


Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

0 Answers  


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  


Explain the use lookup tables and Aggregate tables?

0 Answers  


Explain the key challenges that you face while performing etl testing.

0 Answers  


how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers  


how do u automate Extraction process?

1 Answers  


Categories