Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is data merging,data cleansing,sampling?

Answers were Sorted based on User's Feedback



What is data merging,data cleansing,sampling?..

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

What is data merging,data cleansing,sampling?..

Answer / prasuna

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

What is data merging,data cleansing,sampling?..

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

What is data merging,data cleansing,sampling?..

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

Post New Answer



More Informatica Interview Questions

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,


What is the use of incremental aggregation?

2 Answers  


while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,


have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,


write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,






How would you copy the content of one repository to another repository?

0 Answers  


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  


Describe an informatica powercenter?

0 Answers  


Can we create two repositories on same database instance in oracle?

0 Answers  


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,


What is Java Transformation? what are the uses of it?

0 Answers   TCS,






Categories