How can u execute the sql query through unix?
What is the Primary key for Dimension table?
what is the primary key for Fact table?
Answer Posted / subhash
executing the sql query through unix:
sqlplus -s <userName>/<passWord>@<HostName> <<EOF >
testData.txt
set pagesize 0
select sysdate from dual;
EOF
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How many types of stage?
How do you import and export the datastage jobs?
I have a few records just I want to store data in to targets cycling way how?
What is ds designer?
Have you have ever worked in unix environment and why it is useful in datastage?
How to implement complex jobs in data stage?
What is the use of datastage director?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How can we improve the performance in datastage?
What are the repository tables in datastage?
What are the components of datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the differentiate between data file and descriptor file?
how to abort the job its matain duplicates?
Is the value of staging variable stored temporarily or permanently?