DSXchange

Hi,

by using remove duplicate stage duplicate data will be removed but i want to caputured the duplicate data to one target table

how to solve it?

Hi,

by using remove duplicate stage duplicate data will be removed but i want to caputured the duplicate data to one target table how?

Hi, 1. I have a source like id name sal 1 aaa 1000 2 bbb 2350 1 aaa 1700 3 ccc 3690 1 aaa 4000 2 bbb 3000 in target duplicate records must be caputure 1 aaa 1000 1 aaa 1700 2 bbb 2350 How to solve it? 2. How to capture only the Duplicate record for source using SQL query?

Hi

What are the different way to release the locked job?
other than DS director-cleanup resource

can u explain me in detail?

Hi,

i have a string as 20050920 in date type
how to convert date string to 20/9/2005

what date function should be used?

Hi

i have a string like "ap_re_tfg_bftr"

what is the function to find how many "-" symbol is present in a string

Pls help me

Thanks

Hi

i have a job sequence like s1-s2-s3-s4-s5
s3 has been failed and sequence aborted
need to run again the job sequence but we have to start from s3
since s1 & s2 already executed how to process it?

Hi,

Can we assign a NULL value to stage variable

it is possible?

Thanks

Hi,

i have a source in flat file like
id code1 code2
101 a-1 a-2
142 b-1 b-2
...
and the required target column is
id code
101 a-1
101 a-2
142 b-1
142 b-2
.....
How can i get the required target?
pls help me to slove it

Thanks

Hi,

i want to learn unix command,

where i can learn those unix command related to Datastage

can any one say me the website for it

Thank you

Hi,

How can we write test cases? give me one eg
(ie) what r the test cases for sort stage

Hi,

1. Can any one say the diff b/w static and dynamic hash file?
2. How to release the job lock?

How can you compile and run your PX routines?

Hi,

How to import EXCEL files in Data Stage 7.5