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
No Answer is Posted For this Question
Be the First to Post Answer
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
how to identifie,is it innerjoin,leftouter join in lookup?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
what is the diff b/w switch and filter stage in datastage
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
How do you register plug-ins?
Difference between JOIN,LOOKUP,MERGE?
how to call sequential generator in datastage?
Explain connectivity between datastage with datasources?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?