What is data merging,data cleansing,sampling?

Answers were Sorted based on User's Feedback



What is data merging,data cleansing,sampling?..

Answer / rekha

DATA MERGING : IT IS THE PROCESS OF INTEGRATING THE SOURCES
WITH SIMILAR STRUCTURE AND SIMILAR TYPE
TABLE A
ENO ENAME
100 REKHA VARCHAR2(10)
TABLE B
ENO ENAME
101 SAHAN VARCHAR
SO U CAN MERGE TO COMMAON DATATYPE STRING IN THE ABOVE CASE
dATA CLEANSING :
IT IS THE PROCESS OF IDENTIFING THE INCONSISTANCIES AND
INACCURACIES

DATASAMPLING:
ARBITARILY CHOOSING THE RECORDS FROM GROUP OF RECORDS FOR
TEST

Is This Answer Correct ?    2 Yes 0 No

What is data merging,data cleansing,sampling?..

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

What is data merging,data cleansing,sampling?..

Answer / rakesh

Data Merging:-
Is the process of merging non similar structure data (or)similar structure data into target warehouse system;

Data Cleansing:-
IS the process of converting source Non-Unique data format into unique data format into target warehouse system.

sampling:-
it is the process ,orbitarly reading the data from
group of records.

Is This Answer Correct ?    0 Yes 0 No

What is data merging,data cleansing,sampling?..

Answer / dr.jornalist

Datamerging: This is the process of

Datacleansing:- Removing the Data inconsistencies and
Inaccuracy

Data sampling:- Arbitorily taking the data from the group
of records for the sample purpose.

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More Informatica Interview Questions

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  


What are the data movement modes in informatcia?

3 Answers  


What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,


what is degenerated dimension table with scenario

2 Answers   HCL,


How will you update the row without using update statergy?

10 Answers   CTS,


surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,


How to display null values on a target & non-null values on a target?

3 Answers  


without using rank transformation how can we rank items by using some other transformations

2 Answers  


lookup transformation with screenshots

0 Answers   TCS,


in which situations do u go for snowflake schema ?

2 Answers   TCS,


In session log thier should not be a single error how will u do

3 Answers   HCL,


Categories