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 will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
how does work server jobs?
Notification Activity
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
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.
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
How do you get log info into a file?
On which Dimension Table you implemented SCD Type in your Project
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.
Can we use Round Robin for aggregator?is there any benefit underlying?
What are the functionalities of link partitioner?