i/p
1,a,1000
2,b,2000
3,c,3000
i want to get o/p as
o/p
1,a,3000
2,b,4000
3,c,5000
how it can be done on using datastage?
Answer Posted / saran
in TFM stage we are mapping i/p records to o/p
then i/p metadata appear in o/p link then go to required column o/p link write there derivation whatever we want
in TFM stage
ex--- ano,aname,amt
1,a,3000
2,b,4000
3,c,5000
column derivation write like this (amt+1000)
Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
What are the steps needed to create a simple basic datastage job?
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
What are the types of containers?
what are the errors,warnings in datastage
what is repositery?
root tree will find which is server job and which is parallel job?
how do u catch bad rows from OCI stage? And what CLI stands for?
What are the functionalities of link partitioner?
What is orabulk stage?
Differentiate between operational datastage (ods) and data warehouse?
Name the command line functions to import and export the DS jobs?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Name the third party tools that can be used in datastage?
What are orabulk and bcp stages?
Define orabulk and bcp stages?