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 meant by LDAP users?

1133

---

What is a snowflake schema?

942

---

What are the features of complex mapping?

1110

---

Enlist the various types of transformations.

974

---

What are the measure objects?

1133

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4059

---

How are the sources and targets definitions imported in informatica designer?

1070

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1047

---

What is standalone command task?

1278

---

What is InformaticaPowerCenter?

1090

---

What is domain and gateway node?

1128

---

What is a node in Informatica?

1010

---

What is Session and Batches?

1055

---

What are the components of Informatica? And what is the purpose of each?

999

---

Does an informatica transformation support only aggregate expressions?

991

---