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 you join flat file, oracle as a sources?

Answer Posted / vijay

First you convert the data from flat file into oracle , so
now we have two oracle db's then easily we can join these
two sources using join stage.

I have also faced this question at IBM US.

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between symmetric multiprocessing and massive parallel processing?

1124


what is the use of skid in reporting?

2366


Explain datastage architecture?

1383


Can you implement SCD2 using join, transformer and funnel stage?

1534


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1364


How do you import and export the datastage jobs?

1146


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2432


Differentiate between hash file and sequential file?

1051


What are transforms and what is the differenece between routines and transforms?

1043


What are the job parameters?

1208


What is the sortmerge collector?

1118


What are the different types of lookups in datastage?

1047


Terminate Activity

1260


How do you import and export data into datastage?

1221


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1863