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
- 8491 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 session partitioning?
List few etl bugs?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are the various tools used in etl?
What is ROWID explain ?
What are the ETL Testing Operations?
how do u decide whether u need to do aggregations at database level or at Informatica level?
What do you understand by the term ‘transformation’?
how do u set partition points in the mapping?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
Identifying the bottlenecks in various components of Informatica and resolving them.
Teradata 
