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
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
WHAT are unix quentios in datastage
Explain the importance of surrogate key in data warehousing?
wt is the diff b/w odbc and oracle stage
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
What is usage analysis in datastage?
How can we improve performance of data stage jobs?
what is mapping lookup
How can we select pr retrieve the particular row in dataset by using orchadmin command?
how can we extract data with out having any common column
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?