can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
- 2 Answers
- 8549 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / birendra
Yes we can clean data by using informatica through
expression transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
What is full load & incremental or refresh load?
how do u decide whether u need to do aggregations at database level or at Informatica level?
what do u do when DB time takes more?in sap bi
what is the meant by Normalization and de-normalization?
Define Dynamic push down optmization?
what is HISTOGRAM? how to generate statistics?
flat filevalidation in informatica
what are the facilities provided by data warehouse to analytical users?
Explain about etl data integration software?
Two different admin users created for repository are________and_________.
What is factless fact schema?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Teradata 
