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

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,

What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

Why update strategy and union transformations are active?

0 Answers  

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

Why touse stored procedure in ETL Application?

2 Answers  

what is the architecture of any Data warehousing project?

5 Answers   IBM,