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 |
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
What are variable ports and list two situations when they can be used?
What is aggregator transformation in informatica?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How many input parameters can exist in an unconnected lookup?
What do think which one is the better joiner or look up?
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 are the limitations of pushdown optimization technique ? Advance thanks
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??