DSXchange

Is there a difference between using Oracle Connector or Enterprise stage for loading data into Oracle tables from a functionality or performance point. Can anyone pls forward me some information on the difference b/w those.

That worked well Pandeesh. Thank you.

I have a many jobs that create a logfile after the job is complete. I use the DSJobLog after jobs routine to create the logfile. The file is created in the following format. Here JB_Master is the jobname JB_Master_20111220_122954.txt Now after the job log is created, a job is built to read this file...

I have a comma seperated sequential file. It has a one of a column like this. I am struggling to read this. "DOS 5, WINDOWS 3.1, MOUSE, 3.5"" DIS", When I sprcify w/o quotes, then it is placing the values 'DOS 5' and 'WINDOWS 3.1' in seperate columns. But whne I specify quotes, t...

Craig - that worked good. Why didnt I think of this. I was always trying to use the escape character.

I have a strign like this assigned to a column: "IBM G52 17"" COLOR MONITOR (476)" I want to convert this to IBM G52 17 COLOR MONITOR (476) Tried using the following in Trim. But it gives a syntax error: Trim(Trim(ToTfm.DESCRIPTION, "\""), " ") Any inputs...

Thank you Craig. That solution worked well.

I have 3 cols like this: Col1, Col2, Col3 ----------------------- ABC, , , DEF, , , XYZ I need to convert this into a single row: Col1, Col2, Col3 ----------------------- ABC, DEF, XYZ I tried using an AGG, but it did an implicit conversion into some numbers. Is it possible to do it in any other way...

Worked like charm.

I have a file that is dropped a by a system which has the Timestamp attached to it in this format. FileName_YYYYMMDD_HHMMSS.txt This file gets dropped into our system and we need to read it to load it into a table. Is there a way to read it without modifying the file name using any Unix commands. Th...

I am trying to use 'dsjob -report' option to capture statistcs like Start and End times. Isit possible to capture information like an 'Error; messaeg that Datastage throws in the log file. Is there any way to get it other than reading the Datastage log file? Thank you

Thank you everyone for your valuable inputs. I will try it out.

Thank you everyone for your valuable inputs. I will try it out.

Thank you RAy. Will check using reject link.

I have a date column that has a value like 11/30/20011. THis is a an invalid date format. SO, I was trying to use this below condition in transformer and Iw as expecting the value to be NULL.But it turns out that it is giving a value like 11/30/2001. Looks like it is takign the first 4 characters of...