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 |
how do u reduce warnings
how many types of remove the duplicate records?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
What are some different alternative commands associated with "dsjob"?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
Can you filter data in hashed file?
Difference between JOIN,LOOKUP,MERGE?
how to find no.of records in sequntial file itself?
tell me abt Datastage trigger?
how to delete one row in target dataset
difference between function and procedure...
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help