Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.



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

How many types of transformations supported by sorted input?

0 Answers  


What are the key benefits of ETL Testing?

0 Answers  


What do you understand by the term ‘transformation’?

0 Answers  


what are the production issues in datastage?

0 Answers  


two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  


Explain the use lookup tables and Aggregate tables?

0 Answers  


what are the different Reporting and ETL tools available in the market?

3 Answers  


how many steps are there in etl process?

0 Answers  


Compare etl & elt?

0 Answers  


I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

0 Answers  


what is the difference between OLTP database and data warehousing database?

4 Answers  


Categories