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...

  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

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

what is data modeling?

0 Answers  

without using ETL tool can u prepare a Data warehousing and maintaining?

3 Answers  

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

0 Answers  

What is granularity? Please explain with example

1 Answers   IBM,

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

3 Answers   TCS,

Can anyone explain me a scenario from banking and finance...more precisely a mapping

0 Answers   IBM,

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  

Is hadoop a etl tool?

0 Answers  

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

3 Answers  

What are the differences between sql override and update override?

0 Answers  

Can u access a repository created in previous version of Informatica?

0 Answers  

For more ETL Interview Questions Click Here
Categories