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 |
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
what is ds administrator used for?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
How a source file is populated?
WHAT IS FORCE COMPILE?
What is the default padding character?
What are the types of hashed files in data stage
Describe stream connector?
How to reverse the string using SQL?
how to find out number of records imported into source file?
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.
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this