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
- 11413 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / saran
ihn the job
seq--->tfm----target
in tfm stage take extra col as salary and create parameter for that salary
and take one stg variable in this call the parameter and map to o/p link salary column
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meta stage?
How do you generate sequence number in datastage?
What are the areas of application?
Explain Quality stage?
What is the precedence of stage variables,derivations, and constraints?
Explain ibm infosphere information server and highlight its main features?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How do you schedule or monitoring the job?
What are datastage sequences?
Define Job control?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is the command line function to import and export the ds jobs?
Give an idea of system variables.
What is "fatal error/rdbms code 3996" error?
