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

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

How to delete data which is not in source table?

0 Answers   IBM, Saama Tech, Wipro,


Define Dynamic push down optmization?

0 Answers   HP,


what do u do when DB time takes more?in sap bi

0 Answers  


Define slowly changing dimensions (SCD)?

0 Answers  


A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  


what is data modeling?

0 Answers  


what is meant by drill through?(Mascot)

1 Answers  


Difference between flat files and relational sources?

0 Answers  


Give the benefits of data integration suite?

0 Answers  


What are various etl tools in the market?

0 Answers  


Can u access a repository created in previous version of Informatica?

1 Answers  


Explain different types of partitioning?

0 Answers  


Categories