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

Answers were Sorted based on User's Feedback



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

Answer / maruthi

ys we can clean data by using informatica upto a extent,by
using expression transformation by using below varaibles
1.)ltrim,rtrim,ifnull,isnull,such so many fn u can get in
transformation

Is This Answer Correct ?    4 Yes 0 No

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

Answer / birendra

Yes we can clean data by using informatica through
expression transformation

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

flat filevalidation in informatica

0 Answers   Hewitt,

what is pmrep command?

0 Answers  

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

0 Answers  

How to fine tune mappings?

0 Answers  

how do u implement scheduling in Informatica?

1 Answers   Cognizant,




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

0 Answers  

how do u set partition points in the mapping?

0 Answers  

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

0 Answers  

State the differences between shortcut and reusable transformation

0 Answers  

where we cannot use sorter Transformation. if we use then we will not get correct data?

0 Answers  

what is the indicator file and where it is used?

1 Answers  

how do u implement unconn.stored proc. in a mapping?

1 Answers  

For more ETL Interview Questions Click Here
Categories