Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) outpu

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no
common column)
output should contain merged data(8 columns)
Please let me know how to achieve ??

Question Posted / palthepu_santosh

3 Answers
7100 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain mer..

Answer / sukanta

As per your question two files have same no of records

take first file's 5 column to a expression
transformation,add a output column in it let say 'A'.create
a mapping variable let say 'countA' having datatype
integer.Now in port 'A' you put expression like
setcountvariable(countA).

take second file's 3 column to a expression transformation
,add a output column in it let say 'B'.create a mapping
variable let say 'countB' having datatype integer.Now in
port 'B' you put expression like setcountvariable(countB).

The above two is only meant for creating common fields with
common data in two pipeline.

Now join two pipe line in a joiner transformation upon the
condition A=B.

Now join the required 8 ports to the target.

You get your target as per your requirement.

Regards
Sukanta

Is This Answer Correct ?

12 Yes

1 No

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain mer..

Answer / moorthy g

You Can create dummy port for each source Qual. then connect
to Join Trans., and Join two dummy port.in Joiner
Transformation.

Is This Answer Correct ?

5 Yes

1 No

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain mer..

Answer / moorthy g

You Can Use Union Transformation for combine two flat files

Is This Answer Correct ?

1 Yes

14 No

Post New Answer