Question { 19675 }

How to extract original records at one target & Duplicate
records at one target?

Answer

First Pipeline:

SQ--Sort---Tgt1

Second Pipeline:

SQ--Lkp on Tgt1--If The value is matched from both the table
send it to Tgt2.

Use target load plan while u run the session...

Question { 7699 }

i have an aggregater in my mapping and no group by port on
any column and i ampassing 100 rows through aggregater,so
how many rows i will get as out put from aggregater

Answer

session becomes failed

Question { IBM, 11316 }

suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?

Answer

SQ---->AGR---->RTR---->TGT
SEQ--->RTR

1) Pass all records to Agr
In AGR take count port ion taht give count(empno)
2)Next create SEQQUENCE GENERATOR connect nexval to router
3) Int RTR Create one Group called 1st half
In that give nextval<=count/2
4) Connect to TGTs from 2 groups (1st half and Default)

Question { 5960 }

Please create a mapping where I have source which has one column with name like Aman_Gupta
Rakesh_Mehra
Sachin_More
I want the target field should contain the name in reverse order i.e Gupta_Aman
Mehra_Rakesh
More_Sachin.

Can you please tell me what transformation would be needed to do this.

Answer

In eXP transformation create 3 ports like:
name1:select substr(name,1,instr(name,'_',1,1)-1)
name2:select substr(name,instr(name,'_',1,1)+1)
O_Name:name2||'_'||name1)

Question { iGate, 9578 }

Write a query to display Which deptno is containing highest
Sal > avg (sum (Sal)) of all deptno;


Avg (sum (Sal)) o f all deptno= 9675
Deptno, sum (Sal)
10 8750
20 10875
30 9400

Answer

select * from emp a where sal>(select avg(sal) from emp b
where a.deptno=b.deptno)

Question { Cap Gemini, 8929 }

If the source has duplicate records as id and name columns,
values:
1 a, 1 b, 1 c,
2 a, 2 b,
the target should be loaded as 1 a+b+c or 1 a||b||c, what
transformations should be used for this?

Answer

SQ--->SORTER---->EXP---->AGR---->TGT

1.First pass all records into sorter
seect sort key on id.
2. An pass records into EXP
In exp creat 4 pors like
v_id=id
v_name=nme
v_name1=iif(id=v_id,name||'+'||v_name,name)
o_name=v_name1
3.Next pass all to agr
ini agr creat one port like
o_name_t=last(o_nme).
4.Pass to Target