Answer Posted / babu

Hi,


SRC-->SQ(ENABLE DISTINCT )-->EXP-->TRG

OR
IN EXP T/R TAKE 4 VARIABLE PORTS AND OUTPUT PORT,
SRC HAVEING THE COLUMNS LIKE COL1,COL2,COL3
SRC-->SQ-->SRT(PLEASE TAKE ALL ARE KEY PORTS)-->EXP
(VAR IS IIF(VAR1=COL1 AND VAR2=COL2 AND
VAR3=COL3),1,0)
VAR1=COL1
VAR2=COL2
VAR3=COL3
OUT=VAR
-->UPD(IIF(OUT=1,DD_REJECT,DD_INSERT))-->TRG

IF ANY THING WRONG PLEASE LET ME KNOW.
8861145051

Is it possible to define a single node as a Gateway node as well as worker node?

1115

---

what is the -ve test case in your project.

2400

---

Can we create two repositories on same database instance in oracle?

1084

---

What is sequence generator transformation in informatica?

1067

---

What is a passive transformation?

1092

---

What can we do to improve the performance of informatica aggregator transformation?

1089

---

Explain sessions and how many types of sessions are there?

1000

---

Enlist the differences between database and data warehouse.

1113

---

What are the differences between oltp and olap?

969

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2140

---

How to extract the informatica rejected data?

1211

---

How to do unit testing in informatica? How to load data in informatica ?

1111

---

How does the aggregator transformation handle null values?

1143

---

What are the informatica performance improvement tips

1083

---

what are the Methods For Creating Reusable Transformations?

1164

---