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 |
What is the difference between operational data stage (ods) and data warehouse?
what is the difference between == and eq in UNIX shell scripting?
how to transfer file from one system to another system in unix? which cmd to be use?
which memory is used by lookup and join
Can you implement SCD2 using join, transformer and funnel stage?
why do u need the IOS upgradation in a FC switch
Demonstrate experience in maintaining quality process standards?
What are the benefits of datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks