How to create user defined environment varibale(parameter)?



How to create user defined environment varibale(parameter)?..

Answer / kiran

u can create parameter in 2 way 1.job level params 2.project
level params.
Job-Level: when u want to create job level params ,go to job
properties and use it.

Project -Level :when u want to create project level,go to
DS-Admin and click on environment variable and difine which
parama u need and open design go to job properties and call
thos params (which u defined in DS admin) in job properties
and use it.

Is This Answer Correct ?    19 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,


in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,


how does work server jobs?

1 Answers  


Notification Activity

0 Answers   CTS,


input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,


1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

0 Answers  


How do you get log info into a file?

1 Answers  


On which Dimension Table you implemented SCD Type in your Project

0 Answers  


i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,


Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,


What are the functionalities of link partitioner?

0 Answers  


Categories