can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
Answer Posted / 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 |
Post New Answer View All Answers
how do u set partition points in the mapping?
What are the modules in Power Mart?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
Explain about enterprise scalability and roi of data integration suite?
Explain about the data integration suite features?
what is pmrep command?
Mention few test cases and explain them?
What is grain of fact?
What is etl process?
Give the benefits of data integration suite?
can be used COM component in Informatica ?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
How can we use external procedural logic in informatica?
Explain me ETL project architecture in Detail?
Identifying the bottlenecks in various components of Informatica and resolving them.