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
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 the use of server?
what are the data modeling tools you have used?(polaris)
what do u do when DB time takes more?in sap bi
what is pmrep command?
what is pmrep command?
Which transformation we use to convert 'NA' to 'Not Available'
What are the names of the layers in etl?
what are the different Reporting and ETL tools available in the market?
What is full load & incremental or refresh load?
What are snapshots?
what is the difference between cardinality and Nullability?
what are the reports developed in sap bw project and what is the requirement for developing it?