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
- 11350 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
What could be a data source system?
What are the primary usages of datastage tool?
Define Routines and their types?
How many Key we can define in remove duplicate stage?
What are sequencers?
How to implement complex jobs in data stage?
What is the flow of loading data into fact & dimensional tables?
What is the difference between account and directory options ?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What all the types of jobs you developed?
Explain entity, attribute and relationship in datastage?
What are the components of ascential data stage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is datastage?
What are the different options associated with dsjob command?
