Hi all, explain one complex business rule that you had in your
project and how did you accomplish it using DS?
explain any scenario which you have faced
| Is This Answer Correct ? | 1 Yes | 1 No |
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
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
What are the primary usages of datastage tool?
how to abort the job its matain duplicates?
How many types of stage?
what is time dimension? and how to populate time demension
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)