1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.

Question Posted / jakki


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can impl..

Answer / 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

More ETL Interview Questions

what are variable ports and list two situations when they can be used?

4 Answers   Satyam,

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers  

Explain about power designer data modeling software?

0 Answers  

what is the meant by Normalization and de-normalization?

2 Answers  

When do we analyze the tables? How do we do it?

0 Answers  




In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

3 Answers   Accenture,

we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  

What is a mapping?

0 Answers  

What is granularity? Please explain with example

1 Answers   IBM,

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  

what is the meant by Normalization and de-normalization?

0 Answers  

What are the different etl testing categories as per their function?

0 Answers  

For more ETL Interview Questions Click Here
Categories