Answer / dj

please give the clear picture of this logic

Answer / kamleshmishra291

After SQ Take Aggr group by empid and create a variable port Rows_count=count(1)
Take a router after aggr and create two groups one for uniqe and one for duplicate
in uniqe condition = Rows_count=1
duplicate group condition= Rows_count>1
connect unique group to tgt1
connect duplicate group to java transformation---
add following codes
for (int i=0;i<count;i++)
{
o_empid=i_empid;
o_ename=i_ename;
o_loc=i_loc;
o_sal=i_sal;
generateRow();
}

connect java transformation to tgt2

Answer / isha

Actually this question is - If any record have duplicate value then put it in T1 and If count is 1 then put in T2.

We have to use aggregator and have to group records based on empid and name

If count(empid) > 1 then T2
If count(empid) =1 then T1

Answer / abhishek guddu

src->sq->aggregator->router->target1
|->target2
AggregatorT/F

EMPID -> (GROUP BY)
O_COUNTID(EMPID)-OUTPUT PORT
<- COUNT(EMPID)> 1
ROUTER T/F
GROUP
ONE - CONDITION-> 0_COUNTID ->TARGET1(SECOND TARGET)
DEFAULT->TARGET2(TWO TARGET)

ONE GROUP RETURN DUPLICATE EMPID AND DEFAULT WILL UNIQUE.

Answer / sivakumar

SQ-->EXP-->ROUTER-->TRg
EMPID
IN_EMPID
in exp t/r
create variable port v_flag in that write the following condition
IIF(EMPID = IN_EMPID ,'1','0')

in router develop 2 conditions for v_flag
the values in the true will b directed to one output which we get the duplicated values

Answer / chiky

sq-->router--target1
|__target2

in router create one group and another default
coundition : decode(empid,201,true,decode
(empid,202,true,false))

connect group one in target table one
connect default in target table two

Answer / redflower

src->sq->exp->router->trg1
->trg2

create one variable port and write the substr() function
ename like k% is goes to one trg and remaining records goes
to another trg by using router t/r

Answer / ramesh

target1
SQ->Router->
target2

1.In router create one group and specity
the condition empid=201 or empid=202.
2.It is connected to target1.
3.Default group is connected to target2.

Thanks & Regards
Ramesh

Answer / krish

using AGG we get can't get the above o/p

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

Can you create a flatfile target

3 Answers   ABC,

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

Enlist the various types of transformations.

0 Answers  

How can informatica be used for an organization?

0 Answers  

"Change cache" in Informatica ?

2 Answers  

Parameter and variable differences

0 Answers  

How to extract sap data using informatica?

0 Answers  

How many ways you create ports?

1 Answers  

When to use normalization transformation other than cobol source?

2 Answers  

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers