Interested to Buy Any Domain ? << Click Here >> for more details...
I have file with empid,empname and I want to load these two
fields along with sal in my target
1)salary must be same for all the records
2)I want pass the salary at run time
- 7 Answers
- 11161 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / saran
ihn the job
seq--->tfm----target
in tfm stage take extra col as salary and create parameter for that salary
and take one stg variable in this call the parameter and map to o/p link salary column
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different options associated with dsjob command?
What is the difference between hashfile and sequential file?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Is the value of staging variable stored temporarily or permanently?
To see hidden files in LINIX?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is the difference between in process and inter process?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
root tree will find which is server job and which is parallel job?
What are stage variables, derivations and constants?
What are the different kinds of views available in a datastage director?
If you want to use the same piece of code in different jobs, how will you achieve it?
How a source file is populated?
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 enhancements made in datastage 7.5 compare with 7.0?
