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
- 7604 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
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 |
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
How to delete the data in dataset?types of deleting the data in dataset?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
How a server job can be converted to a parallel job?
How can we improve the performance in datastage?
How a routine is called in datastage job?
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
what are the types of nodes
where we use column generator stage in real time scenario?
Teradata 
