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
- 11459 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
how to sort two columns in single job in datastage.
What are some prerequisites for datastage?
Difference between in process and inter process?
How to RD using transformer?
What are the differences between datastage and informatica?
Can you define merge?
What are the types of views in datastage director?
What are routines in datastage? Enlist various types of routines.
Can you highlight the main features of ibm infosphere information server?
How to clean the datastage repository?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is process model?
describe the Steps to confiure a Qlogic switch
What is the difference between validated and compiled in the datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
