Answer / bharath

Use query
>select * from tab1,tab2;

You get Cartesian Product of two table rows
if tab1 having m no.of an tab2 has n no of col
then mXn (m by n) rows are returned.

Answer / subhash

to the both file we need to add one DUMMY column(value is
like '1', we can use Column generator for this DUMMy column
generation)
then we can JOIN these 2 files based on this DUMMY column.
so, each column of File1 will join with each column of File2
i.e. 5*10= 50 records will come into output.

Answer / datastageboss

The question seems to be incomplte , I am preassuming
that there will be duplicate records in both set of data
on a key say K1

use a join stage , the join type will be full outer join
and key will be K1 ( mentioned above)

At the output link we will receive 5*10 =50 records

Answer / varaprasad rayi

Hi Bharath ,
this is question under datastage also if u have any idea please send me
mailid:rayprasad05@gmail.com

Answer / vinod upputuri

use copy stage and funnel stage to make duplicate records.

SEQ>>COPY>>FUNNEL>>TARGET

the solution for this stupid question asked by interviewer:

SEQ>>COPY>>>4links>>>FUNNEL STAGE>>>SEQ.

in seq stage: sed -n '1,50p'

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

CHANGE CAPTURE

0 Answers   CTS,

Explain the ChangeApply stage?

11 Answers  

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

How do you reject records in a transformer?

0 Answers  

Differentiate between hash file and sequential file?

0 Answers  

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,

Does datastage support slowly changing dimensions ?

0 Answers  

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

What are the benefits of datastage?

0 Answers  

How did you reconcile source with target?

2 Answers   HP,