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

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...

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.

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.

WHAT IS FACT TABLES?

2 Answers  

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

---

What is meant by pre and post session shell command?

0 Answers  

---

What is resilience time?

0 Answers  

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

What is the cumulative sum and moving sum?

0 Answers  

---

Explain grouped cross tab?

1 Answers   Accenture,

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---