DSXchange

Hi,

While generating Data Rule Exception report, I can only see maximum of 10k exception records in report. But in reality, I have around two lakhs of exception records. Could you please advise me how to capture/view all the exception records in Data Rule Exception report?!

Chulett,
I did import on multiple jobs. Not able to figure it out

Hi,
We are doing migration of Jobs from 7.5 to 8.5.
When im importing, getting the below waring in 8.5. Please assist.

Warning:
Line 1334814: UnKnown property name 'Ba'.
Object =V4A0.
Class=CAnnotation.

Hi, Please advise how to achieve the below scenario in Datastage 1) Insert one header record for each 100 batch records corresponding to source records. Eg., IP--> Source 250 records. OP--> 1 header 100 Batch 1 header 100 Batch 1 header 50 Batch 2) Constraints for Header--> One column in header will...

Ray,
The expected output needs to be "2011-02-28 11:12:13.000000"...!
Please advise

Ray,
My Business rule is to calculate the Timestamp value which is 3 months before current timestamp and NOT on the total number of days (90).

I tried Julian date option which produce result based on total number of days(90) not on the months.

Please advice how to achieve ...!

Objective:
Timestamp value which is 3 months before of CurrentTimestamp().

Please assist...!

Post the actual, unedited error from your job's log. There should be an Oracle in there somewhere as well, me thinks... Please find the log below... I am clueless :( Item #: 109 Event ID: 2009 Timestamp: 2011-03-14 10:52:49 Type: Info User Name: dsdsx Message Id: DSTAGE-DRS-0105 Message: E0302_PXR....

We received the issue in Production region. In Development im getting the right result.
Please advise any significant for the error code.DRS-0123.

Thanks

Hi,
I am using DRS stage for target Oracle database.
When im trying to insert data, getting the below error.
No constraints has been set.
Please assist.

DSTAGE-DRS-0123`:`Row Rejected

Thanks,
Prabu

For 1 & 3 you can use a Folder stage to write out the records to dynamic files based on a key column. Not sure what #2 means as there are no "updates" to sequential files. ... #2... If new records arrives in the source for the 2nd run , the requirement is to add to record to the exist...

Add Records dynamically to sequential file in column wise. Scenario: Source: Field1 Field2 Field3 Field4 UKI1 1 M 2D UKI2 2 K 4E UKI2 3 T 7U UKI3 2 L 2D UK1 4 S 2A Target File1: UK1 ----------- 1 4 M S 2D 2A File2: UKI2 ------------ 2 3 K T 4E 7U File3:UKI3 ----------- 2 L 2D Could someone assist ho...

I am new to datastage. Any one please advise... what is Phantom error? Why it occurs..? Any document on this.... Thanks!