DSXchange

Hi All

When i am connecting to the Oracle database thru OCI Stage ,i am getting error message like "TSN name could not be resolved"

when i am importing the meta data i am able to view the data.

Please replay back if any one get the solution.

Regards,
Mohan

Hi all,

What is diffrence between datastage TX and Datastage Enterprise edition,if any one have any URL or materials please share.

Regards,
Mohan

Hi all, When we create project in Datastage contents of project are stored in Universal file or in database? When i gone thru the forum one of datastage guru written like as follows Select Count(*) FROM DS_JOBS where NAME NOT LIKE '\\%'; Select NAME FMT'50L' FROM DS_JOBS where NAME NOT LIKE '\\%'; I...

Hi all,

Please let me know how to run the datastage job in unix env(what is the command).

Regards,
Ramu

This is the final stage in job and hash file having 5 laks records

While loading from Hash file to Sql server table it is taking 28 rows/sec

Hi all I have different sources like SQL server table ,.CSV files and my target is SQL server. Stage which i am using is ODBC stage. While loading taget table is taking 28 rows/per second (i have to load 5 laks recods) it taking arround 5 hr to load. Please suggest me Is any way is there to improve ...

Hi All

Is there any way to compare two .dsx files having same code but diff environments.

Mohan

Hi All,

My source is oracle and targer is also oracle.

Problem: My source table structure is chaging randomly,by changing minar changes in my job i have to run job again with new structure.

Is there any way to resolve this problem.

Regards,
Mohan.

Hi All,


Ex :

Sno
1
2
3
4
5
6


From above data i don't want to populate 3,4,5 values to target .

I written in transformer like sno<>3 or sno<>4 or sno<>5

But i am getting all data into target.

Please help me if any body knows solution.

Mohan

Hi all,

My requirement is to load txt file into XML file ,if any one knows please explain me the steps.

Thx and Regards,
Mohan

I am able to split date part ,but How to split the time portion
Is there any function to split the time portion.

Regards,
Mohan

Hi all, My source is text file having one column date value is "1/28/2008 1:46:55 PM",this date i have to populate in a SQL server While loading i am getting error like "1/28/2008 1:46:55 PM is an Invalid date" Can any one let me know how can i resolve this problem. Regards, Mohan

Hi

How to eliminate warning messages in Datastage server edition (7.1 Version)

Thanks & Regards,
Mohan

Hi All, When i ran the job i am getting Following error ,from following error how can i find exactly in which record is giving problem. DataStage Job 5132 Phantom 3624 Program "JOB.1850638995.DT.145306556.TRANS5": Line 346, Nonnumeric data when numeric required. Zero used. DataStage Phanto...