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

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

Tell me the syntax of Configuration file?

1 Answers  

What is oci?

0 Answers  

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

how to call sequential generator in datastage?

1 Answers   IBM,

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

What is the flow of loading data into fact & dimensional tables?

0 Answers  

I have 100 records how can I load at a time from the single time

1 Answers  

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

0 Answers   IBM,

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 all the types of jobs you developed?

0 Answers