DSXchange

you can use generic stage. In the generic stage you can run data validations ( transformer has limitations in UI what can be done (cant lookup in a transformer b/c it doesnt allow lookup ( ofcourse lookup can be done with transformer in server jobs but thats besides the point. ) but here you can) yo...

Convert("/:","",Oconv(Iconv(internal_date, "D2/"),"DYMD[4,2,2]"))

im betting qt_ky is right as well, it looks like its probably a 2nd monitor. Remember the extend the displays in screen resolution settings.

I know this thread is old but this could help. One reason this could occur, which is what happened with one of my jobs, is within the same lookup if you have two key columns looking up and both have the same column name being looked up to two different lookup fields. In this scenario the not found i...

I had the exact same problem.

The reason datastage complains is:
In the data that field has null in the field it is complaining about. So as you did when you set that field to null, it runs fine.

"xml_assemble_aqi_files,0: Input 0 consumed 0 records. '"

means no records are being received by the xml stage. So probably the input files have no records.

The problem is the DBR-CD either 'C' or 'D' is coming in a different column and the AMT assoicated with that DBR-CD is coming in a different column. Also in the input stream there are other columns coming in that needs to be mapped to output but should not be sent to agregator since I dont want to g...

If the sum of the credit amount is not higher than the sum of debit amount Then that means Sum of debit amount is higher than the sum of credit amount so then subtract sum of the credit amount from the sum of the debit amount and set the DBCR-CD to D. If there is only one type of transaction for an...

From DS V8.5 there is an New XML Stage (that encompasses all aspects of xml input, output) encompassed in one stage. 1. With the xml stage can import the xsd and validate against the data. Validation is done (can choose minimal or strict validation) Data Type has illegal value item that cannot be nu...

I know this is an old post. Just wanted to put my wisdom out there. "If I supply null (ie SetNull() ), it generates <elementname xsi:nil="true"></elementname> " I had the exact same problem when I was running my interface. With the new XML Stage DS 8.5 In the XML Composer Step un...

just came to that realization couple of hours after I posted the topic. Did exactly that by sending a flow with just CA and FL records and another flow with records <> CA and FL. Later used a funnel to reunite them together before sending to target dataset. Thanks for getting back to me same day Ray...

I am getting health data for different states. I am giving my own logic in the transformer for the states CA and FL. Following this is a lookup In the lookup, I am looking up on two key values. coverage code input file = coverage code from lookup data set form no input file = form number lookup data...

yes thanks craig. I did come across that thread where you mentioned it so I did send a email to editor@dsxchange.net as well.

good to know. It has been 2 full business days. My status now says premium member when i reply. However I still cant view any premium content. Hopefully I am able to view by the end of the day today :cry: i did follow up with the membership director so he is aware of it I am trying to view this thre...

smart