deptno wise to find max and min,and sum of rows and in target to company wise maximum
Answer / nish
could you please elucidate the scenario?
question is half baked
| Is This Answer Correct ? | 0 Yes | 0 No |
Give example for FACTLESS FACT TABLE in real-time scenario.
Notification Activity
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 the command line function to import and export the ds jobs?
CHANGE CAPTURE
AGGREGATOR default datatype
In which situations we can use normal and sparse lookup stages
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How many types of views are there in a datastage director?
When we will go for Data elements?
How to Remove Duplicate using SQL?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?