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

Answer Posted / birendra

Yes we can clean data by using informatica through
expression transformation

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do u extract data from different data sources explain with an example?

1774


What are the different etl testing categories as per their function?

531


Define Dynamic push down optmization?

1907


what are the types in error loging?

1629


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

1520






what is the main role of FI on business

1623


what is an ETL or ETT? And what are the different types?

6922


list and discuss two approaches for updation of target table in Informatica and how they are different.

1729


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1369


where is the cache (lookup, index) created and how can you see it.

1563


What is the difference between Data Warehousing and Data Mining?

543


Mention few test cases and explain them?

541


What are the different Lookup methods used in Informatica?

513


Compare ETL & Manual development?

547


can be used COM component in Informatica ?

1614