DSXchange

we have V.8.1

I agree "reconcile debit and credit" should be topic heading and think if we can put credit record in loop unit the credit amount is filled with debit amount and hold on all DUE_DATE's of debit records and transfer residue positive amount from each credit loop to next credit record and it ...

Hope it helps to understand my problem 1) Input file has debit and credit records 2) separate debit and credit records 3) sort on DUE_DATE descinding for debit and credit records on CUSTOMER_NUM , PART_NUM and DUE_DATE 4) match credit and debit on CUSTOMER_NUM and PART_NUM, for all matched groups ap...

Need to apply logic in datastage to get bekow result Create duplicate CREDIT records to adjustments amount TO old DEBIT DUE_DATE and as showen in below result. The amount total for ADJUSTED_AMOUNT will be same as input MATCH KEY:CUSTOMER_NUM,PART_NUM (between CREDIT and DEBIT RECORDS) Input: RECORD_...

For data warehouse which is best approach

Server jobs vs Parallel jobs

I recommended both based on case by case in development in version 8.1.

Can some one help me with pros & cons fact sheet?

It is a good strategy to use only Parallel job.

Thank you

Create three char of first name and put heavy negative wt if three letters don't match,

You will be needing a lot of data analysis before defining the what king of parsing rules are needed because just fixing your current name pattern might not fix entire data cleansing required before standardization or matching. Step one- Identify know data patterns and unknown data patterns with exa...

chulett wrote:Do an exact search for "Oracle client version 0 is NOT supported", there are two Resolved threads here on that topic. They should help. ...

those are different error's, I have no problem running from director, only problem is when i schedule.

Odd. Can you post the complete, unedited error and let us know if this is only an issue with jobs that access Oracle or if somehow this is affecting all jobs? :? ... It is only with Oracle plugin stage, all other and ODBC stage jobs are running fine in schedule mode. Ora_Param_Upd: Connect failed: ...

Hi,
I am getting below error for parllel jobs when I schedule them, other wise they run fine manually.

"Oracle client version 0 is NOT supported"

DS 8.1
AIX 6.1
all 64bit

Regards

What hardware / OS are you running? With very few exceptions DataStage is 32bit, just because you are in a 64bit environment doesn't mean every app you run is 64bit. :? it is AIX 6.1 on 64bit IBM tech support said DataStage 8.1 dosent't carry progress ODBC driver for this version. Information serve...

answer for filed 2: if Count(B, " cat") > 0 then Change(B, " cat","") else if Count(B, " dog") > 0 then Change(B, " dog","") else '' answer for Field 3: if Count(B, " cat") > 0 then 'cat' else if Count(B, " dog") > 0 the...

Can some one help with connecting UniData files residing on windows server and

I have DataStage 8.1 on 64 bit UNIX box.


Thank you

chulett wrote:Does this help?

viewtopic.php?t=122258 ...

Thank you

Can some one help me how to conert scientific to number

1.23456000000000000E+05 to 123456 and back

Thanks