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'

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

What are the different plug-ins stages used in your projects?

0 Answers  

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---

1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,

---

How many areas for files does datastage have?

0 Answers  

---

---

Define data aggregation?

0 Answers  

---

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,

---

What steps should be taken to improve Datastage jobs?

0 Answers  

---

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

---

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 Answers  

---

How to initialize environment variables?

4 Answers   Infosys,

---

How do you start developing a datastage project?

0 Answers  

---