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

Enlist some properties of sessions.

1055

---

How to generate sequence numbers?

1071

---

What does reusable transformation mean?

1118

---

How many ways are there to create ports?

1307

---

What is informatica? Why do we need it?

1083

---

How do you load only null records into target?

1198

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2294

---

How to create a non-reusable instance of reusable transformations?

1098

---

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

1137

---

How do you set a varible in incremental aggregation

1866

---

explain one complex mapping with logic? sales project?

6656

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1980

---

What is lookup transformation?

1023

---

How to delete duplicate row using informatica?

1019

---

What happens when a session fails and you click on recover?

1110

---