can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
- 2 Answers
- 7428 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
how to connect to a flatfile through ftp in informatica
what is the difference steps for data modeling?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Explain do we need an etl tool?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
What do you understand by the term ‘transformation’?
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?
if i have a query as flat file how can we load data to target table
What are the different Lookup methods used in Informatica?
what is the use of server manager?
How many types of transformations supported by sorted input?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What is abap? What are idocs?
Do we need an ETL tool? When do we go for the tools in the market?
What is etl process? How many steps etl contains?
