can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
Answer Posted / murthy
yes,there are many examples for this I will give one let's
take expresion using for ltrim and rtim operation,date
conversions etc.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a mapping?
What is tracing level and what are the types?
How many steps etl contains explain with example?
what is the meaning of upgradation of Repository?
Can we create Hierarchies in generic datasources?
what are the session parameters? How do u set them?
Explain and compare etl & manual development?
What are materialized views & where do we use them?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What do you understand by the term ‘transformation’?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
can cubes contain measures ?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is the difference steps for data modeling?
how do u handle performance issues in Informatica . where can u monitor the performance ?