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

What is informatica? Why do we need it?

1051

---

What is incremental aggregation?

1026

---

What is the command used to run a batch?

1004

---

How you can differentiate between connected lookup and unconnected lookup?

1016

---

What is joiner transformation in informatica?

1000

---

How many transformations can be used in mapplets.

1883

---

How might you approve all mappings in the archive all the while?

968

---

What is the use of code page?

1023

---

How to go to the older version for a mapping?

1038

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2132

---

Define sessions in informatica etl?

978

---

which one is better performance wise joiner or look up

1034

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1878

---

Tell me about MD5 functions in informatica

884

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1903

---