DSXchange

Pls give a brief information about Job Deployment in Datastage.

hi,
sorry server windows

Hi,
Windows vista supports datastage 7x.
Please inform me.


Advance Thanks

Hi,
I have a source table where in I have data with time stamp.

every day i have to refersh data into target table in a particular time.

how can I insert/update without using hash file concept.

Thanks in advance

Hi All, In server job I'm using ORACLE OCI BULK stage for loading target oracle table. But while loading, it's giving me fetal error "Unable to initialize the connection to Oracle Server". In this case use of ORACLE OCI BULK stage is recommended so can't replace it by any other stage. Than...

Hi,

I want to fetch records from a table 'A' based on a condition-
where A.field > B.field . B is another table.
What stage can be used to apply this filter.

Thanks in Advance

Hi,
I am trying to insert 5,00,000 records from sql server to sybase
using odbc stage. the performance is very bad- 5 rows/sec. Any inputs.

Thanks in advance

Hello, Well i am not much old to Ascential DataStage. But i am facing a problem. I have created a set of DataStage Server Jobs(DataStage Server is in Window). This working fine, i have to hand it over to Operation team.. Is there a way these jobs can be run through window command line? Is it posible...

Hi All,

I have a job in which, I have to calculate the date of previous 3 monhts from today's date.
It means current date - 3 months, can anybody tell me how can I achieve this with the help of Datastage-PX 7.5.1a ?

thanks in advance

Hi, I have input stage which is a fetching data with a query. And then connected to a transformer stage, which is used as input by 6 different lookups. Each lookup has a input as query and out put as a dataset. Is there a better way to accomplish this as this job takes lot of time to process. Thanks...

thanks

Hi, I have a pipe delimited flat file,i want to read it onto datastage ,so i ended up reading all the fields initialy as Varchar ( as i was unable to read the file with correct metadata : datastage was throwing error of not detecting "|" at so-and-so offset),and now one-by-one i am convert...

Hi, In Ascential DataStage 7.5, I've experienced a job that load a delimited text file and seems to load fine. Recently, we received an update to the file and after the job runs (truncate and load), job only seems to insert the old rows. The new rows don't show up and they are are no errors in Direc...

thanks for all

CustID CustName
1 John
2 Smith
1 Cathi
2 Phil

When i create a hash file with CustID as primary key, i want the output as follows:

CustID CustName
1 John
2 Smith

Any clue how to do it? Thanks a lot in advance.