Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 11384 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / bharath
hi,
use
row generater------------>peek
in designer and load emp table metadata at row gen
and give cycle as the type value=10000 which is
same for all records as u said..
thank u..
please correct if i am wrong...
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is the difference between in process and inter process?
What are iconv and oconv?
how many rows sorted in sort stage by default in server jobs
What are the benefits of datastage?
Describe stream connector?
Difference between sequential file and data set?
What is a merge in datastage?
Define Routines and their types?
How to find value from a column in a dataset?
Could anyone give brief explanation bout datastage admin
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
How to perform incremental load in datastage?
Terminate Activity
What is size of a transaction and an array means in a datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
