Interested to Buy Any Domain ? << Click Here >> for more details...
how to configure databases through datastage
- 2 Answers
- 12232 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 |
Can you filter data in hashed file?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
Name the command line functions to import and export the DS jobs?
Demonstrate experience in maintaining quality process standards?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
if ename='subbu' while running job the job should be abort how come?
What are the different options associated with dsjob command?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
what is the use of skid in reporting?
Difference between in process and inter process?
If you want to use the same piece of code in different jobs, how will you achieve it?
Teradata 
