how to configure databases through datastage

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

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,


How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,


Pls tell me what is troubleshooting in datastage view?

1 Answers  


Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,


What are the important features of datastage?

0 Answers  


What is the difference between informatica and datastage?

0 Answers  


How to initialize environment variables?

4 Answers   Infosys,


HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,


Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,


I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,


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?

0 Answers   HCL,


Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,


Categories