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
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?
What are the some differences between 7.x and 8.x version of datastage?
How do u convert the columns to rows in datastage?
What is the purpose of pivot stage and types of containers in datastage
Triggers,VIEW,Procedures
Name the command line functions to import and export the DS jobs?
How many types of hash files are there?
What are some different alternative commands associated with "dsjob"?
What is the difference between server job and parallel jobs?
root tree will find which is server job and which is parallel job?
What are the functionalities of link partitioner?
What is the difference between datastage and informatica?
What are the types of containers and how to create them?
How do you reject records in a transformer?
What are the steps needed to create a simple basic datastage job?