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

What are the three tiers in etl?

593


What is full load & incremental or refresh load?

686


how do use session mapping parameters ?(in which transformation)

1442


What are your responsibilities as an etl tester?

628


how would u estimate the size of Aggregator transform data and index cache?

1515






what is pmrep command?

1949


A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1828


What is etl process. How many steps etl contains explain with example?

515


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

1757


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

6928


Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

504


what is dynamic insert?

1714


Compare etl & elt?

556


How to increase performance without changing anything in mapping.( In prod)

783


What are snapshots?

540