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
- 10071 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 |
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the difference between datastage and informatica?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
sed,awk,head
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
What are sequencers?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
What is the difference between validate and compile?
HOW CAN WE SEE THE DATA IN DATASET?
Define oconv () and iconv () functions in datastage?
What is the project in datastage?
Teradata 
