What is data merging, data cleansing and sampling?
Answers were Sorted based on User's Feedback
Answer / rekha
DATAMERGING : IT IS THE PROCESS OF INTEGRATING THA DATA
WITH SIMLIAR SOURCE ,STRUCTURE AND TYPE
DATA CLEANSING : IT IS THE PROCESS OF IDENTIFING AND
CHANGING THE INCONSISTANCIES AND INACCURACIES
DATA SAMPLING : IT IS A PROCESS , ORBITARILY READING THE
DATA FROM GROP OF RECORDS
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / dev
Data Cleansing: A two step process of detection and
correction of errors in a data set.
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / amsarasu
data merging :multiple detailes values are summarised into
single summaeised value.
data cleansing:to eliminate the inconsistant data
sampling:it is the process ,orbitarly reading the data from
group of records.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / sudheer
The main thing Merging of data is nothing but integrating from multiple source systems. It is in 2 types
1.Horizontal merging(Join)
2.Vertical Merging(Union)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sridhar
Data Merging:The process of standing the Structure Of The table(table name,column name,column type.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sarat
datacleaging:it is the process of identifying and changing
inconsistency and inacquries
datamerging:it is process of integreated multiple
inputsource into singleoutput with similar srtucture and
datatype
| Is This Answer Correct ? | 1 Yes | 2 No |
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to do the error handling of if ur source is flatfiles?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
What if the source is a flat-file?
What is native users?
What is the functionality of update strategy?
how the server recognises , if the session fails after loading the 100 records in to the target
What is the term PIPELINE in informatica ?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
how you will maintain version?
What is substr in informatica?