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
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
Define data aggregation?
What are data elements?
Differentiate between hash file and sequential file?
What is the different type of jobs in datastage?
Where the datastage stored his repository?
How to read multiple files using a single datastage job if files have the same metadata?
How to manage date conversion in Datastage?
How many types of sorting methods are available in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Terminate Activity
What is the precedence of stage variables,derivations, and constraints?
What is the difference between operational data stage (ods) and data warehouse?
What is "fatal error/rdbms code 3996" error?
What is job control?
What can we do with datastage director?