Interested to Buy Any Domain ? << Click Here >> for more details...
What is data merging,data cleansing,sampling?
- 4 Answers
- 10343 Views
- I also Faced
- E-Mail Answers
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 |
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
How will you check the bottle necks in informatica? From where do you start checking?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
How to list Top 10 salary, without using Rank Transmission?
Explain lookup transformation in informatica
Performance tuning in UNIX for informatica mappings?
What are the types of groups in Router transformation?
What is a candidate key?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is rank index in rank transformation?
Teradata 
