Question { Patni, 5888 }

following table

source target
name gender name target
a1 male a1 female
a2 female a2 male

i want a1 female update to target how will do?

Answer

The purpose of ur question is to update male to female and
female to male .......... is it so, then

Source --> SQ --> Expression --> Target

Use an expression transformation and make 1 variable port
in it say gender_check, put the condition in it as

IIF(gender=male,female,male)

make a output port say gender_new and give the value of
gender_check as output.Use gender_new as output to target.

Kindly revert if this worked.

Question { IBM, 6151 }

if we have certain records,if i need to get 5 th rec for the
first time to the target,when i run it for next time,i need
to get 6th rec...like that it should process.what wil be the
procedure to achieve it??

Answer

I guess this should work ........

Source --> SQ --> Exp --> Filter --> Exp --> Target
|
|
SG

Firstly create a mapping variable say $$count and give it
the default value 5.
Create a port in Expression say Srno. and connect the
sequence generator to it (so that it will mark the rownums).
Then in Filter place the condition Srno = $$count
In the second Expression create an extra port and give it
the value SETCOUNTVARIABLE($$count) (this will increment
the mapping variable).
Next time the job runs it will take value of $$count as 6
and so on ........

Kindly revert if this worked ........

Question { 10852 }

What type of sorting algorithm does the Sorter
Transformation use, to do its sorting Operation?

1. Bubble sort
2. Insertion sort
3. Shell sort
4. Merge sort
5. Heapsort
6. Quicksort
7. Bucket sort

Answer

Thanks for the answer.

Can you please say where did u find this information?