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
- 8380 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 |
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are various etl tools in the market?
when should one create lookup transformation ?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
how do u identify the changed records in operational data?
what are the session parameters? How do u set them?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is fact? What are the types of facts?
How many types of transformations supported by sorted input?
What are the key benefits of ETL Testing?
Difference between flat files and relational sources?
what are the data modeling tools you have used?(polaris)
Teradata 
