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
- 9279 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
How to reverse the string using SQL?
What are the functionalities of link partitioner?
What are the main features of datastage?
What are datastage sequences?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How rejected rows are managed in datastage?
What are the types of hashed files in data stage
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the difference between server job and parallel jobs?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the purpose of pivot stage and types of containers in datastage
Define Data Stage?
How a routine is called in datastage job?
what is the difference between == and eq in UNIX shell scripting?
What is the roundrobin collector?
