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

How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 Answers  


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

0 Answers  


SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,


What do you understand by active and passive transformations?

0 Answers  


what are Lookup caches options? Including persistent caches.

1 Answers  


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  


how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com

2 Answers   TCS,


in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?

2 Answers   Accenture,


what is pmrep command?

0 Answers  


what is session partitioning?

0 Answers  


what is the use of server?

0 Answers  


Explain and compare etl & manual development?

0 Answers  


Categories