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
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
How rejected rows are managed in datastage?
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)
Lookup constraints
Thanks to all people who are posting their comments...
What are the main differences you have observed between 7.x and 8.x version of datastage?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
In merge stage can we update the values?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what is the exact difference between dataset and fileset in datastage?
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)
What are data elements?