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
Is it possible to query a hash file?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
which r the connectors used in san?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
What is a folder? Difference types of stages?
Highlight the main features of datastage?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?