Question { UHG, 9333 }

Hi guys,

please design a job with derivation(solution).
write exact conditions.

My requirement
Source table
emp_no qualification
1 a
1 c
2 a
3 c
3 b

Target table
emp_no qualification
1 b
2 b
2 c
3 a

Here every employer have three qualifications i.e a,b and c.
what ever source table dont have some qualification, that
will be move to target table.
Like above.

Hope u get the point.

Thanks.

Answer

Since Each Employee should have 3 qualification then Primary
file should be like below because Primary is always Static.
In which terms it should be like this.
Primary file:
empno,qua
1,a
1,b
1,c
2,a
2,b
2,c
3,a
3,b
3,c

And this is our Reference data we have.

RefFile:
empno,qua
1,a
1,c
2,a
3,c
3,b

Primary,ref-->lookup-->output & Reject.
and match the empno and qua and set lookup failue = reject
at reject file
U will get desired output.
Thats it.

Question { Cap Gemini, 12041 }

file1
1
2
3
4
file2
3
4
5
6

output should be in three targets
T1 T2 T3
1 3 5
2 4 6

how to do this? can any one help?

Thanks

Answer

ok
Follow this:

seqStg1,seqStg2-->Funnel-->Filter-->seq1,seq2,seq3.

Since we have less data to sort and to remove duplicates use
hash partition and unique option at input link.

Thats it.

I wonder why such a goofy question asked by capegemini?