DSXchange

hi, I have a job that reads from multiple files and comibines all the records and transforms and writes to a xml file. There is a requirement where in i need to capture the number of records read from the multiple files and write it to a file. The link that goes to the transformer stage in a job can...

Hi, I m running a job that would read from file and insert the data into the table. the job aborts logging following the director, Oracle_Enterprise_28,0: Failure during execution of operator logic. Oracle_Enterprise_28,0: Fatal Error: Invalid time I rechecked at the oracle stage all the defined pro...

Hi ray,

I m using the same UserID that is used in Toad...inspite of that it is throwing this error

Regards,
Meghana

Hi, I m creating a job that loads the data from a csv file to a table. In between u have a lookup being done. The records that pass the lookup are written to a table otherwise goes to a sequential file. The table in which i m trying to load is having indexes define on the some columns. i used Rebuil...

Hi ray, Pls tel me where can i find the skip property in the sequential stage. And also tel me where to go and delete a query posted. I chose the option(Edit/Delete a post) but was unable to delete one. thnx Meghana Hi, I have a CSV format file where in first two rows corresponds to the column names...

Hi,

I have a CSV format file where in first two rows corresponds to the column names.

My concern is how should i take care of skipping the first two lines in a sequential stage of px job.

Thnx,
Meghana

Hi, I have a CSV format file where in first two rows corresponds to the column names. My concern is how should i take care of skipping the first two lines in a sequential stage of px job. I m sorry.....i want to rephrase the question asked.......In sequential stage i need to process the data from th...

Hi,

I had posted a query regarding how to handle excel as input.
The reply came was saying to handle thru ODBC stage.But for this there needs to be UNIX based ODBC driver for excel...How do i check for this driver.

thnx,
Meghana

Hi, Example : Consider u have a file demo.txt to be taken to another server by name :dsfgna and to a location XYZ ...and username/password = meghana/**** for the dsfgna server...the parameters that u have mentioned wuld take the following values - Server Name: dsfgna User: meghana PWD: **** Remote P...

Hi,


When u go to the option clean up resource... when u click on show all PIDs in Locks Tab, u can see the PID for the job that has been locked.
Check the username for the correspondibg locked PID in Process Tab.
You can find username who has locked the job.

Thnx,
Meghana

Hi,

I have a excel file which needs to be loaded into a table. The xls file wuld reside in a Unix Server. How do i handle this situation.