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 the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

---

How to do unit testing in informatica?

0 Answers  

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

What are the connected or unconnected transforamations?

2 Answers  

---

What is the capacity of power cube?

1 Answers  

---

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

---