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

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1199


What do you mean by worklet?

1064


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2131


What is the function of union transformation?

1129


What is the sequence generator transformation in informatica?

1181


How do you load only null records into target? Explain through mapping flow.

2016


Why filter transformation is an active one?

982


Why do you use Mapping Parameter and mapping variable?

1763


What are the prerequisite tasks to achieve the session partition?

1250


What is union transformation in informatica?

1146


What is a filter transformation?

1043


How would you join a node to the already existing domain?

1127


Explain the different lookup methods used in informatica?

1042


What is informatica etl tool?

998


Differentiate between router and filter transformation?

1011