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

What are active and passive transformations?

658


What is mapplet in informatica?

607


What are the restrictions of union transformation?

589


What is the surrogate key?

651


How can you differentiate between powercenter and power map?

641






What is rank transformation in informatica

701


What are some examples of informatica etl programs?

544


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

668


What is InformaticaPowerCenter?

702


What are the types of caches in lookup? Explain them.

560


What is a surrogate key?

569


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1863


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

718


What are the databases that informatica can connect to windows?

595


Can we create multiple integration service on single repository?

711