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
how to write server Routine coding?
What are the components of ascential data stage?
What is "fatal error/rdbms code 3996" error?
How do you import and export data into datastage?
How do you reject records in a transformer?
What are datastage sequences?
What are the types of containers in datastage?
What is a folder? Difference types of stages?
What is the purpose of pivot stage and types of containers in datastage
What are the benefits of datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is ibm datastage flow designer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.