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 >> Informatica
  2. Suggest New Category

what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?

Question Posted / itsranjan

Answers were Sorted based on User's Feedback



what are the transformations that are used in data cleansing ? and how data cleansing takes place ..

Answer / avinash

Expression tranformation is used in data cleansing.

If ur target table consist of not null column and source
table consisting null columns so assign some value in
expression tr.
and then pass data to target.

Is This Answer Correct ?    1 Yes 0 No

what are the transformations that are used in data cleansing ? and how data cleansing takes place ..

Answer / shashiall

Source Qualifier Transformation and Expression
Transformation are used for Data cleansing.
Data types ,Date formats,null ..not null
constraints ..these r main things considered in the data
cleansing.

Is This Answer Correct ?    1 Yes 0 No

what are the transformations that are used in data cleansing ? and how data cleansing takes place ..

Answer / d.chandrasekar

Hi Friends,

My point of view FILTER AND EXPRESSION TRANSFORMATIONS are
used to data cleansing.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is left outer join?

3 Answers   L&T,

How do you update the records with or without using update strategy?

0 Answers  

How can informatica be used for an organization?

0 Answers  

Which are the different editions of informatica powercenter that are available?

0 Answers  

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

How to join three sources using joiner?

0 Answers  

what is mean by grouping of condition column in lookup transformation?

1 Answers  

For more Informatica Interview Questions Click Here
Categories