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

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

What are the different type of jobs in datastage?

0 Answers  

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

Define oconv () and iconv () functions in datastage?

0 Answers  

convert yyyy mm dd to dd mm yyyy?

4 Answers  

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

How can you write parallel routines in datastage PX?

0 Answers  

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

5 Answers   IBM,