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 |
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
how can we check whether a particular cache is static or dynamic?
In session log thier should not be a single error how will u do
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Define filter transformation?
What is difference between maplet and reusable transformation?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
What is the difference between SOURCE and TARGET BASED COMMITS?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
WAT IS TEXT LOAD?
How to convert flat file into xml file? How to tune joiner?
How the facts will be loaded? explain