what is the Difference Between Datastage Server Edition and
Parallel Edition?
Answers were Sorted based on User's Feedback
Answer / vinay kumar
datastage server edition is single node execution,where
parallel edition is multi node execution, depening up on
partitioning of s/w.
| Is This Answer Correct ? | 9 Yes | 0 No |
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
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?
how does work server jobs?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.
What is a range lookup?
What are the functionalities of link collector?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
What are the enhancements made in datastage 7.5 compare with 7.0?
Can aggregator and transformer stages use to sort the data? How ?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
How to create a doccument in datastage?