DSXchange

ray.wurlod wrote:Sort stage (not performing a unique sort) does not drop records. How are you handling nulls in the sort keys? ...

Actually the sort key is a nullable no column.

Sort stage ignores duplicates and does not drop it. What is the sort in the transformer ? Without full design, metadata and sample data it is not possible to comment. Try to locate the missin ... Hello, I think I have confused you. The thing is I am using a sort stage followed by a transformer. I w...

Hello All, I have a simple job extracting data from flat file and using sort and transformer and finally putting into DB. This is a reusable component wherin i would be running multiple instances of the job. Starngely i am able to run this job nicely for all the flat files except one. Of course the ...

Hi Sreeni,

I got the solution. I kept the entire thing under double quotes and it works. i mean paramter ="ab\\read" and it worke.

Anyways thanks for the quick response

You can Use the escape sequence. Its '\' . I use it for $APT_CONFIG_FILE Regards Sreeni Thanks for the reply. Do you mean to say that I should use something like paramter=abc\\\\read. because I have tried this. Shall i keep the escape in quotes?? I don't think I have to. Please let me know how exac...

Hello All, I have come across this issue. I have a userid as abc\\read meaning that it has the escape character in it. I am able to run it when the userid is hardcoded however job gets aborted when trying to pass it as a parameter. I checked the value being passed in the log, it seems to pass the co...

Hello All, I am reopening this issue after an year. I have again come across this issue. I have a userid as abc\\read meaning that it has the escape character in it. I am able to run it when the userid is hardcoded however job gets aborted when trying to pass it as a parameter. As suggested I checke...

Hi All, I have few reusable jobs in my project. They have "allow multiple instances" enabled. These are both parallel and sequencer jobs. These generic jobs are meant to be called by us in our specific sequencers.I mean these jobs are part of everyone's regular sequencers. However when i t...

However, the query is not that simple. I am actually trying to pull last month's data based on a date field from the table. It looks like this: select col1, clo2 from tablename where to_date(col1,'yyyy-mm-dd hh24:mi:ss')) = to_date(to_char(last_day(add_months(sysdate,'yyyy-mm-dd') ||' 00:00:00','yy...

Exactly. You use TO_DATE() to put data into a DATE field and TO_CHAR() to pull it back out again. ... Thansk for the quick response. Yes that's true. However, the query is not that simple. I am actually trying to pull last month's data based on a date field from the table. It looks like this: selec...

I am trying a query by using to_date function using odbc connector stage(to connect to oracle) but it gives following error "Unexpected procedure reference found" The format of date fields seems to be different from what we have for other database stages like Oracle enterprise stage or odb...

Helo All, We have a requirement wherein I have to use upsert option while writing into oracle enterprise stage. Since my requirement is to update some already existing records based on some where clause and once those existing records are updated, the insert should take place, so I have taken 'updat...

Hello All, We have a requirement wherein we have a EBCDIC file (after being ftped). We are reading this file using sequential files stage(SFS) with format properties set to EBCDIC. Now my question is can we directly load this sequential file to a dataset stage and expect that it will implicitly conv...

Hello all, I have a requirement wherein my filename has some special characters. the filename is omething like this ----'TH.ABC.FRE.12(0)' Anyways i am able to read the file and run the job successfully if i am hardcoding the name of the file, however if i try to parameterise this file name with par...

hello,

thank you. even i have the same thought, however i tried with few million of records(around 5 million), its not giving any problem even i also beleive staging it to a dataset would be better. well thanks and I would mark this topic as resolved. :D