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


Please Help Members By Posting Answers For Below Questions

what is 'reconsideration error' and how can i respond to this error and how to debug this

2117


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?

596


What are the functionalities of link collector?

623


what is the difference between == and eq in UNIX shell scripting?

972


Does datastage support slowly changing dimensions ?

659






What is aggtorec restructure operator?

722


Describe routines in datastage? Enlist various types of routines.

579


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.

2726


How many areas for files does datastage have?

638


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1615


Can we use target hash file as a lookup ?

2814


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.

2428


If you want to use a same piece of code in different jobs, how will you achieve this?

787


What are the benefits of datastage?

721


What is the process of killing a job in datastage?

587