Interested to Buy Any Domain ? << Click Here >> for more details...
how to configure databases through datastage
- 2 Answers
- 12203 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 |
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
how to cleansing data
what is the unix script to run the job? Please mention commands which we use often?
what is diff b/w datastage 8.1,8.5,8.7?
What is size of a transaction and an array means in a datastage?
how to sort two columns in single job in datastage.
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
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?
How many types of views are there in a datastage director?
source contains 2 columns comes to target 4 columns how
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
what is the difference between the join and look up explin me one exmple
Teradata 
