how to configure databases through datastage
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 |
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..
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?
Pls tell me what is troubleshooting in datastage view?
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.
What are the important features of datastage?
What is the difference between informatica and datastage?
How to initialize environment variables?
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
Give example for FACTLESS FACT TABLE in real-time scenario.
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
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?
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.