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
- 11429 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
Can you explain kafka connector?
What are orabulk and bcp stages?
What are the components of datastage?
Why we use surrogate key?
What is the method of removing duplicates, without the remove duplicate stage?
Is the value of staging variable stored temporarily or permanently?
How do you schedule or monitoring the job?
How to read multiple files using a single datastage job if files have the same metadata?
What are some different alternative commands associated with "dsjob"?
What is data partitioning?
how to sort two columns in single job in datastage.
What are the different options associated with dsjob command?
how to implement scd2 in datastage 7.5 with lookup stage
Notification Activity
Explain entity, attribute and relationship in datastage?
