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 |
How will u find weather dimension table is big in size of a fact table?
What is informatica etl tool?
How to load relational source into file target?
what is the gap analysis?
What did you do in source pre load stored procedure
Can anyone briefly describe abt audit table loading?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
what is mapping performence?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.