can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
- 2 Answers
- 7449 Views
- I also Faced
- E-Mail Answers
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 difference steps for data modeling?
what happens if the info.server doesn't find the session parameter in the parameter file?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What is etl process. How many steps etl contains explain with example?
Difference between flat files and relational sources?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Which type or t/s is used to convert rows into column & column into rows
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
how do u automate Extraction process?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
how do u decide whether u need to do aggregations at database level or at Informatica level?
what is granularity in Data ware House?
Teradata 
