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

how do u implement configuration management in Informatica?

0 Answers  

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  

what are the data modeling tools you have used?(polaris)

0 Answers  

what is the main role of FI on business

0 Answers  

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  




When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  

How many steps etl contains?

0 Answers  

what types of repositories we can create in informatica? in real time in which type of repository we will work on?

2 Answers  

what is the difference between cubes and package in cognos

0 Answers   Cognizant,

we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 Answers  

hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers   SS Solutions,

what is the difference between OLTP database and data warehousing database?

4 Answers  

For more ETL Interview Questions Click Here
Categories