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
what is ds administrator used for?
What is the method of removing duplicates, without the remove duplicate stage?
How you Implemented SCD Type 1 & Type 2 in your project?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Differentiate between validated and Compiled in the Datastage?
Define orabulk and bcp stages?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is a merge?
How do you start developing a datastage project?
What are the job parameters?
What is ibm datastage?
Difference between in process and inter process?
What is the difference between Datastage 7.5 and 7.0?
how to delete one row in target dataset
What are the processing stages?