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.

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

Explain grouped cross tab?

1 Answers   Accenture,

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

---

What is IQD file?

1 Answers  

---

What is difference between a connected look up and unconnected look up?

6 Answers  

---

how can we use sorter transformation in joins?

5 Answers   IBM,

---

How do you implement scheduling in Informatica?

1 Answers  

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

---