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...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

how to configure databases through datastage

Question Posted / anumasula

Answers were Sorted based on User's Feedback



how to configure databases through datastage..

Answer / hanug

To connect to any database we should check if we are able
connect to database from the server. We can configure by
specifying the database in the dsenv file.

Say ex: I am trying to configure to connect to ORacle. In
this case we should configure oracle in the dsenv. We also
need to check if we have the DB user present in the
tnsnames.ora

Once we have done the above steps, we can connect to Oracle
DB using Oracle connector or oracle Enterprise or DRS.

We need to specify Server, user name and DB password to
connect to DB.

By using Orachaestrate schema or Connector wizard, we can
import the DB objects.

Is This Answer Correct ?    1 Yes 0 No

how to configure databases through datastage..

Answer / loga

Hi,


Am using DS 8.5 and Oracle 11g.
I want to connect Oracle with Data stage with 'oracle connector' stage. I am getting error message connection failed. Can any one tel me how to connect these.... Am new Data stage, its highly appreciated if you given answer with snapshots. Regards, Loga

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

Main Function of the Staging area in DWH ?

2 Answers  

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

6 Answers   IBM,

how does work server jobs?

1 Answers  

What is PX?

2 Answers   IBM,

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

How do you import and export the datastage jobs?

0 Answers  

root tree will find which is server job and which is parallel job?

0 Answers   IBM,

Can you explain repository tables in datastage?

0 Answers  

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

0 Answers  

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

Define Merge?

0 Answers  

Nls stands for what in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories