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, thangavel
if we want this at runtime why can't u
pass parameters...?
I think,
By RCP we can generate only column names but not column data..
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is 'reconsideration error' and how can i respond to this error and how to debug this
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the functionalities of link collector?
what is the difference between == and eq in UNIX shell scripting?
Does datastage support slowly changing dimensions ?
What is aggtorec restructure operator?
Describe routines in datastage? Enlist various types of routines.
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.
How many areas for files does datastage have?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Can we use target hash file as a lookup ?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the benefits of datastage?
What is the process of killing a job in datastage?