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

what is the difference between the join and look up explin me one exmple

3 Answers  

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,

Explain the situation where you have applied SCD in your project?

0 Answers  

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

What are routines in datastage?

0 Answers  

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

12 Answers   Wipro,

What are the important features of datastage?

0 Answers  

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

For more Data Stage Interview Questions Click Here
Categories