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

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,


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

2 Answers   Satyam,


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

8 Answers   DELL, IBM,


Differentiate between data file and descriptor file?

0 Answers  


what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,


What are the some differences between 7.x and 8.x version of datastage?

0 Answers  


how to find diff between 2 dates without using Icon... funtions?

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,


1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  


what is the use of invokation id

2 Answers   IBM,


A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,


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,


Categories