What is data merging,data cleansing,sampling?

Answer Posted / prasuna

Data Merging: It is a process of combning Non-Similar
structures or Similar structure data into Target Warehouse
system.
To combine Non Similar we can use Joins Concept,For
Similar We can use Union Concept

Data Cleansing:It is a process of converting Non Unique
data format of the source system into unique data format of
Target Warehouse system.

I dont Know definion for Data Sampling..can anyone plz give
the answer...

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an unconnected transformation?

764


What is aggregator transformation in informatica?

628


Mention a few design and development best practices for informatica?

657


What are the main features of Oracle 8i with context to datawarehouse?

1769


What is a predefined event?

750






Can informatica load heterogeneous targets from heterogeneous sources?

814


How does the aggregator transformation handle null values?

801


Explain sessions. Explain how batches are used to combine executions?

694


What are the mapping parameters and mapping variables?

715


Explain about Informatica server process that how it works relates to mapping variables?

714


Explain sessions?

681


Design time, run time. If you don't create parameter what will happen

1519


What are the different clients of powercenter?

699


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1849


What are the modules in Power Center

1317