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

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

How do you implement scheduling in Informatica?

1 Answers  

How can a transformation be made reusable?

0 Answers   Informatica,

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

what is data driven in informatica

5 Answers   IBM,

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

how to use incremental load?

2 Answers   TCS,

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

0 Answers  

WAT IS TEXT LOAD?

3 Answers   Wipro,

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

What is degenerated dimention table?

7 Answers   Patni,