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
- 9775 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / madhu
This can achieve using xmf stage, in create one extra column
as sal and data pass through parameter
Seq----> xmf---> dataset
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the difference between passive stage and active stage?
What all are the different way to run a job?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How do y read Sequential file from job control?
Can you define merge?
How complex jobs are implemented in datstage to improve performance?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
table actions available in oracle connector?
CHANGE CAPTURE
What are some different alternative commands associated with "dsjob"?
Give an idea of system variables.
What are datastage sequences?
How a server job can be converted to a parallel job?
What are the types of containers in datastage?
