What is data merging,data cleansing,sampling?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the transformations that are not supported in mapplet?
Explain sessions and how many types of sessions are there?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
What is the function of union transformation?
Explain about Recovering sessions?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
how to load rows into fact table in data warehouse
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
what is difference between COM & DCOM?
What is the difference between OLTP and ODS?