which is the most complex job in your career? Please tell me answer?
Answers were Sorted based on User's Feedback
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 |
There is no JOb as such complex or easy. It totally depends. This question has been asked to test your knowledge, that's it
Better whatever job you think is most complex for you. explain them
http://goo.gl/atN4AT
www.datagenx.net
| Is This Answer Correct ? | 0 Yes | 0 No |
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to abort the job its matain duplicates?
EXPLAIN SCD
How many Key we can define in remove duplicate stage?
Explain the importance of surrogate key in data warehousing?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
Give example for FACTLESS FACT TABLE in real-time scenario.
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
how to sort two columns in single job in datastage.