help in job logic

[pandeesh]

HI,

Today i have faced this question in interview.
my 2 input files A , B are as given below

A
__

1
2

B
__

3
4

My output file C should be


C
__

1,3
2,4

How to implement this in job level?

Thanks

[chulett]

What was your answer?

[pandeesh]

I dont knw the answer.

Actually i told that in unix level we can do that via

Paste -d ',' A B

But i dont knw how to do in datastage.

Please help me

[chulett]

I'd rather see if you can work it out on your own with some help rather than just provide a solution... teach a man to fish and all that. Did you look to see what paste does? Have you tried to put the requirement into words? A lot of times, simply spelling out what needs to be done can lead you to the solution.

[pandeesh]

ok Craig!! thanks!!

I will try it out and let you know!

[pandeesh]

hi Craig,

I can achieve this by the following design:

2 Seq file stages -----> Transformer stage -----> Seq file stage(record delimiter=',')

We can have 2 fields in the target seq file. Since the record delimiter is ',',

the result will look like 1,1
2,2
3,3


Am i correct?

Is there any other way to do this?

Thanks

[ray.wurlod]

Parallel Transformer stage does not support two inputs.

[chulett]

Ah... but there is at least one that does.

[pandeesh]

Ah... but there is at least one that does.

i don't get you

[SURA]

Examples are always seems to be simple.


A
__

1
2
5
6
B
__

3
4
7

what should be the ouput in C?

[pandeesh]

C should be,

1,3
2,4
5,7
6,

[SURA]

What is your source?

[chulett]

What is your source?

That was noted in the first post.

[chulett]

Ah... but there is at least one that does.

i don't get you

You can't use a parallel transformer to join two data sources.

[SURA]

There is no direct way to do it. Still you can do it.

Need to make one identy col as a key to join two links. Use join stage (full outer for safer) and the in the TFM combined the col.