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

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

What is the need of etl tools?

0 Answers  

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

Clarify the utilization of aggregator cache record?

0 Answers  

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers