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
how to implement scd2 in datastage 7.5 with lookup stage
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
how to export or import the jobs in .ISX file
What are the benefits of datastage?
How do you import and export the datastage jobs?
What is a quality stage in datastage tool?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are the job parameters?
What are the differences between datastage and informatica?
How do you start developing a datastage project?
Describe the architecture of datastage?
Explain Quality stage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How many types of stage?