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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a predefined event?

837


How can you define user defied event?

816


Can we create multiple integration service on single repository?

934


design of staging area?

1797


Explain dynamic target flat file name generation in informatica

831


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1891


What are the prerequisite tasks to achieve the session partition?

942


Explian the Process of deployment groups in informatica

815


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

964


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1833


How to generate sequence numbers without using the sequence generator transformation?

868


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

896


How are the sources and targets definitions imported in informatica designer?

859


What is the session task and command task?

777


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1356