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

What are the processing stages?

0 Answers  

How one source columns or rows to be loaded in to two different tables?

0 Answers  

What is PX?

2 Answers   IBM,

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,

What are some different alternative commands associated with "dsjob"?

0 Answers  

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers  

Have you used Unstructured data?

0 Answers   CTS,

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  

how CAN we remove duplicates in dataset?

2 Answers   IBM,

how to run jon in unix back round process what is command use in runing a job?

2 Answers   HSBC,

What are the components of datastage?

0 Answers