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
- 9774 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shilpasagar
Declare one job parameter SAL_PARAM
Within the job seq -> Transformer -> Target
In Transformer, declare one new column by the name SALARY
and give its value as job parameter (select SAL_PARAM from
the list)
Compile the job and run it. While running it will prompt
you to pass value for SAL_PARAM.
If you pass SAL_PARAM as 45000, then all the emp data will
be populated with emp_id,empname,empsal (45000)
Note: Enable RCP too
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / 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 |
Answer / sirisha
by using transformer stage also we can generate the column &
values also
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / madhu
This can achieve using xmf stage, in create one extra column
as sal and data pass through parameter
Seq----> xmf---> dataset
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / thangavel282@gmail.com
hi ...
they are asking run time so please use rcp
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
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?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.
What is usage analysis in datastage?
why do we need a datawarehouse when we have databases to store data?
What is the use of datastage designer?
What are the difference types of stages?
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.
EXPLAIN SCD
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Give an idea of system variables.
Describe routines in datastage? Enlist various types of routines.
Teradata 
