Search found 246 matches

by kennyapril
Thu Nov 04, 2010 9:22 am
Forum: IBM QualityStage
Topic: Custom rule sets
Replies: 31
Views: 14969

First thing to do is to create a service which has a request of address and I have to use CASS for the accuracy of address and the response from that service would be the standardized addresses from CASS. it goes like...the address provided would be... 1 MICROWSOFT REDMUND WA and I had to send all t...
by kennyapril
Wed Nov 03, 2010 2:49 pm
Forum: IBM QualityStage
Topic: Custom rule sets
Replies: 31
Views: 14969

Thanks for the information!! In a project for the match purpose we are using validity with some rule sets in it. I have to create the same rule sets based on the rule sets of validity so that that could improve the match weight. so my task is to develop a job and service that uses the CASS server mo...
by kennyapril
Wed Nov 03, 2010 9:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

thanks for the quick info!!

so I assume everytime I send the rows to copy stage no issue arises as the rows overwrite.
followed the same way,it works!!
by kennyapril
Wed Nov 03, 2010 8:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

Thanks,

so the stream output can be sent to a copy stage with out output to it
and reject to a table.

can I over write the copy stage each time I run the job?
by kennyapril
Tue Nov 02, 2010 12:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

so to get the rejected rows....Is it continue for the two conditions?
by kennyapril
Tue Nov 02, 2010 12:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

thanks,

I see only two conditions in the lookup
one is condition not met and other one lookup failure
do I need to use continue for these two?
or do I need to assign a new condition, please suggest how can I do that?
by kennyapril
Tue Nov 02, 2010 10:13 am
Forum: IBM QualityStage
Topic: Custom rule sets
Replies: 31
Views: 14969

Custom rule sets

I need to do a batch job using custom rule sets and I am new to the quality stage.

The rule sets which are in the tool right now are out of box so I have to create new custom rule sets.

please suggest me how to crate new custom rule sets?
by kennyapril
Tue Nov 02, 2010 9:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

When I use the output link and reject link that works but my job is to get only the rejected records so I used only the reject link bot the output link.

so I got this error.

Is there a stage other then I look up stage to get only the rejected records as
I need only the rejected records.
by kennyapril
Tue Nov 02, 2010 9:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

The job design is ftp stage------>transforrmer(stream to lookup)---------->lookup(and the reference isTable)-------->(reject from lookup)Table The ftp stage is used to read the data from an other server and file comes every week to that server and after reading the file and transform according to th...
by kennyapril
Mon Nov 01, 2010 12:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

I tried to use only a reject as said in my message but I see an error for that which says
"An UnIdentified error has occured"


please suggest!!
by kennyapril
Fri Oct 29, 2010 12:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

thanks,

When I do a look up there should be a stream and a reject.
Can I link only a reject from the lookup to the table with out the stream link?
by kennyapril
Thu Oct 28, 2010 2:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataBase loading
Replies: 20
Views: 6939

DataBase loading

A file is sent to the server every week and the records from the file should be loaded into a table. Suppose first week there are 100 records second week there may be more than that around 120 to 140. before loading into the table we need to find out only the new ones and load them I mean append to ...
by kennyapril
Mon Oct 25, 2010 8:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Source Name
Replies: 5
Views: 2553

Thanks, Admin created a new dsn for the new database with new definition. The dsn was created on the server in which the database is present now Do I need to load the data using the datastage on that server in which the DSN is created? The file which is to be loaded comes every monday to the server ...
by kennyapril
Fri Oct 22, 2010 9:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Source Name
Replies: 5
Views: 2553

Regularly we connect to the DB which is informix using DSN which is already configured.

But now the DB is DB2 with a new database Do I need a new DSN for that DB on the server?

Do I need to load the data using Information server which is installed on the same server?