Answer / prathibha

Hi,

Source->SQ->Sorter->Expression->FilterTarget.
Lets take a small example for this scenario.
Use a sorter to sort the input data.
ID Name
1 A
1 A
2 B
3 C
3 C

In Expression Transformation declare the following ports:

ID
Name
O_Count= iiF(V_port=ID,O_Count=O_count+1,O_Count=0)
V_port(Variable Port) = ID;

In filter transformation give the condition O_Count =0;
Let me know if there are any suggestions.

Answer / infabee

Expression is a passive transformation. So we can't delete
any row in it. We can achive only by using an active
transformation with/without it (SQ,Filter,Agg..etc).

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

Answer / bijay

The mapping should be like this
SRC->SQ->EXP->TARGET
In source qualifier transformation select 'ENABLE DISTINCT',
then it will send only distinct record to the expression transformtion. And From expression transformation simply connect to the target

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

---

What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,

---

What is a rank transform?

0 Answers  

---

How many ways you create ports?

1 Answers  

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

How does the aggregator transformation handle null values?

0 Answers  

---

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 ?

0 Answers   Puma,

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

---