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 is the use of datastage director?
What are some prerequisites for datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is meta stage?
Can you define merge?
What is the purpose of interprocessor stage in server jobs?
What is ds designer?
What are orabulk and bcp stages?
how to implement scd2 in datastage 7.5 with lookup stage
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is the sortmerge collector?
What all the types of jobs you developed?
What a datastage macro?
Define Data Stage?
Lookup constraints