Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how can we extract data with out having any common column

Answer Posted / 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

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

EXPLAIN SCD

1413


how to write server Routine coding?

2132


What are the different layers in the information server architecture?

1129


Explain datastage architecture?

1405


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3800


What is size of a transaction and an array means in a datastage?

1317


what are the devoleper roles in real time? plz tell i am new to datastage....

2164


What is the purpose of pivot stage?

1172


What is a quality stage in datastage tool?

1081


Differentiate between data file and descriptor file?

1063


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 ?

2025


What is the difference between odbc and drs stage?

1095


How many types of sorting methods are available in datastage?

1075


What are the components of ascential data stage?

1191


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3652