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?!
Search found 13 matches
- Fri Jul 07, 2017 12:56 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: IA11.5-Data Rule Exception report to view all exception rows
- Replies: 1
- Views: 4501
- Mon Nov 14, 2011 8:07 am
- Forum: General
- Topic: Warning While importing jobs in 8.5
- Replies: 3
- Views: 2337
Warning While importing jobs in 8.5
Chulett,
I did import on multiple jobs. Not able to figure it out
I did import on multiple jobs. Not able to figure it out
- Mon Nov 14, 2011 5:20 am
- Forum: General
- Topic: Warning While importing jobs in 8.5
- Replies: 3
- Views: 2337
Warning While importing jobs in 8.5
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.
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.
- Mon Sep 19, 2011 4:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help needed in Datastage Parallel Job implementation Logic
- Replies: 1
- Views: 1632
Help needed in Datastage Parallel Job implementation Logic
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...
- Fri Jul 01, 2011 2:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CurrentTimestamp() before 3 months
- Replies: 8
- Views: 4689
- Thu Jun 30, 2011 11:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CurrentTimestamp() before 3 months
- Replies: 8
- Views: 4689
CurrentTimestamp() before 3 months
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 ...!
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 ...!
- Thu Jun 30, 2011 7:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CurrentTimestamp() before 3 months
- Replies: 8
- Views: 4689
CurrentTimestamp() before 3 months
Objective:
Timestamp value which is 3 months before of CurrentTimestamp().
Please assist...!
Timestamp value which is 3 months before of CurrentTimestamp().
Please assist...!
- Mon Mar 14, 2011 9:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSTAGE-DRS-0123`:`Row Rejected
- Replies: 4
- Views: 4381
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....
- Mon Mar 14, 2011 8:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSTAGE-DRS-0123`:`Row Rejected
- Replies: 4
- Views: 4381
- Mon Mar 14, 2011 7:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSTAGE-DRS-0123`:`Row Rejected
- Replies: 4
- Views: 4381
DSTAGE-DRS-0123`:`Row Rejected
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
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
- Tue Mar 08, 2011 10:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Add Records dynamically to sequential file in column wise
- Replies: 3
- Views: 3053
Add Records dynamically to sequential file in column wise
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...
- Tue Mar 08, 2011 10:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Add Records dynamically to sequential file in column wise
- Replies: 3
- Views: 3053
Add Records dynamically to sequential file in column wise
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...
- Tue Jan 11, 2011 3:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error
- Replies: 1
- Views: 2248
Phantom Error
I am new to datastage. Any one please advise... what is Phantom error? Why it occurs..? Any document on this.... Thanks!