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
- 8371 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 is initial load and what is full load?
what is data modeling?
What is staging area referring to?
What are various etl tools in the market?
what are the concerns of OLTP and DSS systems?
explain the methodology of Data Warehousing?(Polaries)
what are the facilities provided by data warehouse to analytical users?
what is the meant by Normalization and de-normalization?
State the differences between shortcut and reusable transformation
What are the key benefits of ETL Testing?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
how would u estimate the size of Lookup transform data and index cache?
Explain do we need an etl tool?
what is pmrep command?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
