Interested to Buy Any Domain ? << Click Here >> for more details...
can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
- 2 Answers
- 8388 Views
- I also Faced
- E-Mail Answers
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 are various etl tools in the market?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how do u set partition points in the mapping?
What is etl process?
Explain do we need an etl tool? When do we go for the tools in the market?
What is the difference between project backlog and product backlog?
what is session partitioning?
How etl testing is different from database testing?
State the differences between shortcut and reusable transformation
how do u set partition points in the mapping?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What are the types of Data Warehouse applications?
what are the concerns of OLTP and DSS systems?
Compare ETL & Manual development?
What is full load & incremental or refresh load?
