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 do y read Sequential file from job control?
CHANGE CAPTURE
What are orabulk and bcp stages?
Describe the architecture of datastage?
in oracle target stage when we use load option and when we use upsert option?
What is the difference between operational data stage (ods) and data warehouse?
How do you import and export data into datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
I have a few records just I want to store data in to targets cycling way how?
EXPLAIN SCD
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Define Job control?
Where do you see different stages in the designer?
how to add a new records into source?
What are some prerequisites for datastage?