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
What is virtual Data Warehousing?
Explain about power designer data modeling software?
What is the difference between Data Warehousing and Data Mining?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u handle performance issues in Informatica . where can u monitor the performance ?
What is etl process? How many steps etl contains?
What are the different Lookup methods used in Informatica?
what is a worklet?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
explain the methodology of Data Warehousing?(Polaries)
what is granularity in Data ware House?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are cubes and olap cubes?
What is Data Vault???
How many types of transformations supported by sorted input?