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 / 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
How to manage date conversion in Datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Differentiate between odbc and drs stage?
How do u convert the columns to rows in datastage?
Explain the importance of surrogate key in data warehousing?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is ds designer?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
what are the errors,warnings in datastage
Define Routines and their types?
EXPLAIN SCD
How to implement complex jobs in data stage?
What is the flow of loading data into fact & dimensional tables?
Explain datastage architecture?
Notification Activity