Interested to Buy Any Domain ? << Click Here >> for more details...
which is the most complex job in your career? Please tell me answer?
- 2 Answers
- 7526 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pravinsachin
Date job
We are creating calender for next 20 years and we calculating follwing type of column
1) Date SK
2) Month Sk
3)Qurter SK
4)Year SK
5)Week Sk
6) count Days
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How to reverse the string using SQL?
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.
What is orabulk stage?
what is repositery?
Explain Quality stage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How many types of hash files are there?
AGGREGATOR default datatype
Whats difference betweeen operational data stage (ods) and data warehouse?
Triggers,VIEW,Procedures
What is the purpose of pivot stage and types of containers in datastage
What are transforms and what is the differenece between routines and transforms?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
