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 / 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
Define Routines and their types?
What are the important features of datastage?
Explain Quality stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Where do you see different stages in the designer?
Is it possible to query a hash file?
What is use Array size in datastage
How to manage date conversion in Datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the functionalities of link collector?
What is apt_config in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
How do you register plug-ins?
What is job control?
How do you run datastage job from the command line?