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 meta data and system catalog?

2 Answers  

How can you differentiate between powercenter and power map?

0 Answers  

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

Types of error logs in Informatica?

2 Answers  

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

in performance wise union is past,union all is past

2 Answers  

difference between shortcut and reusable transformation?

2 Answers  

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

how to load duplicate row in a target

4 Answers  

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

For more Informatica Interview Questions Click Here
Categories