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'

what is the difference between datasatge and datastage TX?

6 Answers  

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

what is materialized view used datastage?

1 Answers   HSBC,

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers   IBM,

How can we run same job in 1 day 2 times

4 Answers   IBM,

what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

wt is the difference between swith and filter stage

6 Answers   IBM,