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

What is merge stage?

1225


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3264


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2444


Differentiate between data file and descriptor file?

988


What are the types of hashed files in data stage

1058


Why we use surrogate key?

1158


Lookup constraints

1200


What are the various kinds of the hash file?

1095


What is ibm datastage?

915


In Datastage, how you can fix the truncated data error?

1095


Give an idea of system variables.

962


What are the types of jobs we have in datastage?

1021


Which commands are used to import and export the datastage jobs?

1359


How a routine is called in datastage job?

1042


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2164