What are the environmental settings for data stage,while
working on parellel jobs?
Answers were Sorted based on User's Feedback
Answer / kiran
hai ..,
This is Kiran
Your Quetion is wrong.and Environmental variable set in job
properties while using in jobs level and project level set
in DS Admin.
if any send mail me mkk143@gmail.com and call-9393363309
Is This Answer Correct ? | 2 Yes | 5 No |
table actions available in oracle connector?
How can we achive parallelism
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
What is the flow of loading data into fact & dimensional tables?
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
What are the various kinds of the hash file?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
when will you go for dataset and fileset?
What are the environmental settings for data stage,while working on parellel jobs?
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .