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

Answers were Sorted based on User's Feedback



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

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

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

Answer / birendra

Yes we can clean data by using informatica through
expression transformation

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ETL Interview Questions

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

0 Answers  


Explain about round-robi?

0 Answers  


how would u estimate the size of Aggregator transform data and index cache?

0 Answers  


WHY CANT WE SEE THE DATA IN DATASET

1 Answers   IBM,


can be used COM component in Informatica ?

0 Answers  






how do u implement configuration management in Informatica?

0 Answers  


Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,


what is meant by drill through?(Mascot)

1 Answers  


how do u automate Extraction process?

1 Answers  


What are the differences between sql override and update override?

0 Answers  


what is pmrep command?

1 Answers  


hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers   SS Solutions,


Categories