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

How to use pmcmd utility command?

584


What is the function of union transformation?

619


What are active and passive transformations?

654


What is data caches/ index caches?

615


What are the different types of olap? Give an example?

564






Where are the source flat files kept before running the session?

626


Do you find any difficulty while working with flat files as source and target?

677


What is update strategy transform?

578


How to load a Dimension ? and how to load a fact table?

955


What are the uses of etl tools?

650


Enlist some properties of sessions.

634


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1189


What are ETL Tools?

667


What is meant by pre and post session shell command?

626


What is different between the data warehouse and data mart?

630