Answer Posted / 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

What is domain and gateway node?

1204

---

What is meant by lookup transformation?

1178

---

Different qualification between a related rotate toward the sky and isolates look upward?

1035

---

What is mapplet in informatica?

1122

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2185

---

Explain how many types of dimensions are available in informatica?

1168

---

What are the different options available for update strategy?

1047

---

What the difference is between a database, a data warehouse and a data mart?

1197

---

What is different between the data warehouse and data mart?

1111

---

How to do unit testing in informatica?

1226

---

What is informatica etl tool?

1055

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2289

---

Global and Local shortcuts. Advantages.

2085

---

What is a node in Informatica?

1084

---

How to Create a folder using pmrep command?

1218

---