How to use Environment variable's in datastage?(use of process)
To use environment variable at the project or job level, we
should first check if the environment variable already
present at the project level. If the environment variable
does not exist, we should create the one and then it should
be used at the project level or at the job level.
To use the environment variable you just need to add to the
project or job.
| Is This Answer Correct ? | 2 Yes | 3 No |
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
Different ways a project can be moved to production ?...example ….export-import and Version control.
Which algorithm you used for your hashfile?
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
what is a message handler
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
How did you reconcile source with target?
How many input links can you give to a Transformer stage?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
Thanks to all people who are posting their comments...
What is datastage engine?