1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / ksrds.85

Answers were Sorted based on User's Feedback



I have file with empid,empname and I want to load these two fields along with sal in my target 1..

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

I have file with empid,empname and I want to load these two fields along with sal in my target 1..

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

I have file with empid,empname and I want to load these two fields along with sal in my target 1..

Answer / sirisha

by using transformer stage also we can generate the column &
values also

Is This Answer Correct ?    2 Yes 0 No

I have file with empid,empname and I want to load these two fields along with sal in my target 1..

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

I have file with empid,empname and I want to load these two fields along with sal in my target 1..

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

I have file with empid,empname and I want to load these two fields along with sal in my target 1..

Answer / thangavel282@gmail.com

hi ...


they are asking run time so please use rcp

Is This Answer Correct ?    0 Yes 1 No

I have file with empid,empname and I want to load these two fields along with sal in my target 1..

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

Post New Answer

More Data Stage Interview Questions

On which Dimension Table you implemented SCD Type in your Project

0 Answers  

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

What is the default padding character?

3 Answers   IBM,

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,




in aggregator , how can i get the sum in readable format

4 Answers   IBM,

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

what is set mapping in datastage??

2 Answers   ADP,

What are the areas of application?

0 Answers  

How to manage date conversion in Datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories