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 / 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
Describe routines in datastage? Enlist various types of routines.
Where do you see different stages in the designer?
Can you explain players in datastage?
Differentiate between validated and Compiled in the Datastage?
Give an idea of system variables.
What are the various kinds of the hash file?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is usage analysis in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
How can one find bugs in job sequence?
What is ds designer?
How can we improve performance of data stage jobs?
What are stage variables?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?