DSXchange

input file A contains
1
2
3
4
5
6
7
8
9
10

input file B contains
6
7
8
9
10
11
12
13
14
15

Output file X contains
1
2
3
4
5

Output file y contains
6
7
8
9
10

Output file z contains
11
12
13
14
15

How can we do in this in a single ds job in px ?....could you please give me the logic to implement ???

hi,

Could you elaborate a little bit?

On what basis you are sending to output files?

Would be equal no of lines in all the 3 output files?

The contents of the i/p file will be always in sequence?

The input files are always same with the same content?Not a dynamic one?

You are looking for a full outer join between the two. Look at this topic
viewtopic.php?t=124978&highlight=full+o ... join+stage

What is the logic?
Do you want to populate each file with five consecutive values?

You need three joins for three files

One is left outer , one is right outer and one is equijoin...

input file A contains
1
2
3
4
5
6
7
8
9
10

input file B contains
6
7
8
9
10
11
12
13
14
15

Output file X contains
1
2
3
4
5

Output file y contains
6
7
8
9
10

Output file z contains
11
12
13
14
15

i need to populate three output files x,y,z.

output x should contatin the data which is present in the input file A and not present in input file B.

output y should contatin the data which is present in the input file A and input file B.

output z should contatin the data which is present in the input file B and not present in input file A.


I've given the input file records as sample only...not a series of numbers...


How can we do in this in a single ds job in px ?....could you please give me the logic to implement ???

Full outer join.

Three-output Filter or Transformer stage constraining on whether A is null or B is null or neither is null.

Yes, Full outer join will solve your problem
I agree with ray's reply

Can anybody post the job design for this?

Today i had the same question in interview.

Thanks

Hi ray...thanks...logic works fine...