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
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
options available in sequence job to run,validate?
Describe routines in datastage? Enlist various types of routines.
Differentiate between datastage and datastage tx?
How can you write parallel routines in datastage PX?
Define oconv () and iconv () functions in datastage?
What is use Array size 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
What are the different kinds of views available in a datastage director?
What are data elements?
What is data partitioning?
Name the third party tools that can be used in datastage?
what is the use of surogate key in datastage
What are the types of containers in datastage?
How can we improve performance of data stage jobs?