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 is aggregate cache in aggregator transformation?

629


Different circumstance which drives informatica server to expel records?

549


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1964


What is transformation?

655


Explain lookup transformation in informatica

642






have u done any performance tuning? how u ll do?

1853


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4774


How can repository reports be accessed without sql or other transformations?

721


What is a difference between complete, stop and abort?

637


Under what conditions selecting sorted input in aggregator will still not boost session performance?

630


What are the new features of informatica 9.x in developer level?

553


What does “tail –f” command do and what is its use as an Informatica admin.

627


Write the program through which the records can be updated?

512


How you can differentiate between connected lookup and unconnected lookup?

606


design of staging area?

1585