sparse look up

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

sparse look up

Post by kennyapril »

I am using sparse lookup in the ODBC connector.
with the normal lookup I get no errors or warnings but it takes long time to run the job.

Using sparse lookup I see the following warnings...

1.Lookup_254: Schema field prefix in input data set 0 not present in design time information.
Extended field properties for this field will not be available.

2.Lookup_298: [IIS-CONN-DAAPI-000063] Unable to determine association between
statement parameters and table columns. The connector will not be
able to obtain external schema and only limited schema
reconciliation will be performed


3.Lookup_298: [IIS-CONN-ODBC-000105] Connected to Informix, version 09.
52.FC4 .0000 through driver VMifcl22.so.[IIS-CONN-ODBC-000099]
The driver does not support quoted identifiers in SQL statements

Is there anyway to get rid of these warnings?
Regards,
Kenny
Post Reply