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
- 11687 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / shilpasagar
Declare one job parameter SAL_PARAM
Within the job seq -> Transformer -> Target
In Transformer, declare one new column by the name SALARY
and give its value as job parameter (select SAL_PARAM from
the list)
Compile the job and run it. While running it will prompt
you to pass value for SAL_PARAM.
If you pass SAL_PARAM as 45000, then all the emp data will
be populated with emp_id,empname,empsal (45000)
Note: Enable RCP too
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Why do we use exception activity in Datastage?
Nls stands for what in datastage?
What are routines in datastage? Enlist various types of routines.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
To see hidden files in LINIX?
How many types of sorting methods are available in datastage?
Define Job control?
What is the project in datastage?
Describe the architecture of datastage?
whom do you report?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are data elements?
Difference between sequential file and data set?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
