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 / jaini
In order to execute an sql query thru unix, simply write db2 "sql query" and press enter.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is orabulk stage?
Demonstrate experience in maintaining quality process standards?
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...
How many areas for files does datastage have?
Difference between server jobs & parallel jobs?
How do you import and export the datastage jobs?
How many types of views are there in a datastage director?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
what are the devoleper roles in real time? plz tell i am new to datastage....
Have you used Unstructured data?
What are the types of views in datastage director?
describe the Steps to confiure a Qlogic switch
What are the features of datastage flow designer?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.