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 |
1.what is materialized data? 2.how to view the materialized data?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How can one find bugs in job sequence?
How can we improve the performance in datastage?
What are the processing stages?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
how to find out number of records imported into source file?
On which Dimension Table you implemented SCD Type in your Project
Can you define merge?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?