Interested to Buy Any Domain ? << Click Here >> for more details...
how to configure databases through datastage
- 2 Answers
- 12347 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
Difference between sequential file and data set?
how to call routines in stages?
Explain Quality stage?
Which commands are used to import and export the datastage jobs?
Pls tell me what is troubleshooting in datastage view?
What is a quality stage in datastage tool?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
Describe link sort?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
Teradata 
