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

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,

how to validate the jobs

2 Answers   IBM,

What is the command line function to import and export the ds jobs?

0 Answers  

How did you reconcile source with target?

2 Answers   HP,

Where do the datastage jobs get stored?

0 Answers  

Define ds designer?

0 Answers  

How do you generate sequence number in datastage?

0 Answers  

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,