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
describe the Steps to confiure a Qlogic switch
what is the difference between == and eq in UNIX shell scripting?
What is a folder? Difference types of stages?
What is the difference between odbc and drs stage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to implement scd2 in datastage 7.5 with lookup stage
What is the purpose of pivot stage?
How do you reject records in a transformer?
What are the processing stages?
What are the components of datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is apt_config in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How to reverse the string using unix?
Where do the datastage jobs get stored?