DSXchange

select case
when sud.plat_type in ('VST','VLT','LSC') then 'wcc'
when sud.plat_type is null then
(select coalesce(l.comp_abbr_name,'BOG') from line_data l,
service_data au where l.app_id=au.auth_id) end plat_type
from line_data l,service_unit sud where l.app_id=sud.stu_id

Tried with CASE but couldnt get it. Just wanted to give a try before asking my lead.

Could anyone please throw an idea on how to write a query in oracle using below specs? Any help would be greatly appreciated. Looks simple but confusing. using l.app_id=sud.stu_id if sud.plat_type in ('VST','VLT','LSC' ) then display 'wcc' if sud.plat_type is null use l.app_id=au.auth_id display l.c...

Thanks Ray.
You mean, to implement another output link and use otherwise/log and abort after rows as 1.

Can we do this without using an extra link?

Actually the job has already been designed by somebody else.Now i have been asked to implement this logic. I have no other knowledge on this. I know that input date field is coming from a flat file and parameter date is passed in a transformer using a scheduling tool at run time. So I thought can es...

Select * from table_name@dblink;

The above statement is invalid in the connector stage. It should be as below

select * from table_name @dblink;

We should allow a space between table_name and @dblink in the Oracle connector.
Either ways is valid in Oracle EE stage.

Sorry Ray,
I have misinterpreted the requirement. I need to compare the incoming date field with the parameter date and if equal continue else abort the job and return the message with a failed status.
I think this can be implemented in transformer constraint.
Could you please suggest me an idea?

Or elae you can type the same in the note pad, copy and paste in the connector's table name option.

Just type in manually as #schema#.#table_name#
Do not use drop down list of use job parameter in the connector stage for this kind of issues.

Hi, I need to determine a logic for the below scenario. I have an input file name as file_mmddyyyy.txt. Also run time parameter DATE as YYYY-MM-DD . I need to abort the job with a fail status if the date in the input file name that is mmddyyyy is not equal to the DATE from input parameter i.e YYYY-M...

Thanks Guys. I dont have any idea on production. Its taken care of by prod support. I want to tell them to create a new project and import a dsx file into it which would be sent by me. I think this is the easiest of all. Are there any drawbacks if i have to send large no. of jobs? Is there any bette...

I need to export whole DS project into production environment. Can anyone walk me through the steps required to do so? Appreciate your help.

Thanks jwiles.
field 1 --> char(4000) to decimal(15,2)
field 2 --> char(20) to decimal(15,2)

Used stringtodecimal().
Source is a prod. I think i may not change it.

I have used a message handler to demote it to informational.

Thanks Craig. I have successfully loaded all the records. I have handled the rejected records which are coming as '000000' with the below code If IsNull(incolumn) Then SetNull() Else if Trim((incolumn),'0') = "" Then SetNull() Else StringToTimestamp(incolumn,"%mm%dd%1980yy") I ne...

I found that rejected 37 rows are with the data '000000'
I think this cant be converted to any date. How do i handle this?