Answer / vijay

create a one dummy column in both tables .

like dummy x in t1 table,
dummy x in t2 table.

make a inner join .. then u ll get data from both tables.

Answer / ram

Question not clear. can u check your question.

i think you want to know how to extract data from 2 tables
which doesnt have a common column.

Answer / siri

Hi,

If meta data is same u can achieve this in 2 ways.
1) In job properties -> before job subroutine -> cp file1.txt file2.txt

2) Use Funnel

Meta data is not same then you need key.(With out key it is not possible)

Answer / raj

yes. PLZ give me the ans

Answer / sridhar

Use lookup stage .this scenario u will do through lookup
stage .But whatevr You joining columns datatype must be
same.cOrrect me if i am wrong

Answer / bietl

Hi,

it's just simple as this..

Suppose we have two tables T1 and T2.

Now load the two tables to Seq.files as S1 and S2.

T1............ S1

T2............. S2

Now S1 and S2 are our two seq.files load the two files data
by selecting the S2 seq.file option as append then we will
get the S1 and S2 data as same as T1 and T2.

I hope it will clarify ur question

Answer / nagakalyan

by using transformer we can but the joining two tables at
least have same datatype and data

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  

What is the default execution order of the sequential file?

3 Answers  

Terminate Activity

1 Answers   CTS,

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

how to find no.of records in sequntial file itself?

4 Answers  

detail about sdlc

4 Answers  

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,