1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this

Question Posted / narendra

Answers were Sorted based on User's Feedback



There are two file are there .1st file contains 5 records and 2nd file contain 10 records in targe..

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.

Is This Answer Correct ?    10 Yes 2 No

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in targe..

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.

Is This Answer Correct ?    6 Yes 0 No

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in targe..

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

Is This Answer Correct ?    1 Yes 0 No

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in targe..

Answer / varaprasad rayi

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

Is This Answer Correct ?    0 Yes 0 No

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in targe..

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'

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Data Stage Interview Questions

What is the difference between Datastage 7.5 and 7.0?

0 Answers  

convert yyyy mm dd to dd mm yyyy?

4 Answers  

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,




Differentiate between data file and descriptor file?

0 Answers  

How many areas for files does datastage have?

0 Answers  

what is operator combinality in datastage?

1 Answers   TCS,

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

How do you reject records in a transformer?

0 Answers  

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories