DSXchange

Hi All,

Im doing a Sparse lookup on a DB2 table.Its returing the lookup key values as Null eventhough the records in the reference table matches with that of Source table.But for the same Source and reference table,the lookup is working fine for SQL Server.
Please help me in this regard.

Thanks.

Hi

No changes are done either in the target table or in the source table.I have just rerun the job.So if i rerun the job it should get matched with the records in the target table.But it is not happening.

Hi All, I have used Sparse lookup in my referance table.How to construct SQL Statement in referance ODBC for Sparse lookup? By default it is auto generated as follows : SELECT eid, name, address FROM a.Emp WHERE (eid= ORCHESTRATE.eid AND name = ORCHESTRATE.name) with UR For the above,looup is workin...

Hi All, What is the difference between Normal and Sparse Lookup? Im having a Source table containing 9 records and im doing a sparse lookup on target table containing 9 records.The lookup condition used is continue.The number of records from the output link is 387.How is it happening??? What is the ...

Hi all, Is there any function that can be used to calculate Yesterday's date of datatype Timestamp? I tried giving CurrentTimestamp()-1 but when i compiled it shows the error as : "Invalid conversion requested from a dfloat to a timestamp". Actually i have to give constraint in the transfo...

Hi all, I need a logic for delta processing of tables without last update timestamps. Actually i tried this using Change Capture stage.So i considered a table with more than 25 million records. The CDC stage when used will compare the entire records in both Before and After dataset and capture the c...

Yes,Iam writing it in a Sequential stage only.

Hi, I used the sorce file with extn .txt and i have given the record delimiter as end and field delimiter as comma. This is the error msg im getting... <main_program> orchgeneral: loaded <main_program> orchsort: loaded <main_program> orchstats: loaded <main_program> Parameter specified but not used ...

Hi all, Iam new to IBM Information Server.I just created 1 job containg one source a.d one target sequential file and 1 transformer. So when i run the job the target file is getting created and i can view the data in Linux.But when i use the view data option in Sequential stage for both source and t...

Hi all
Thank you all 4 ur respones.I got the solution...

Hi all, I created a parallel job using Difference stage.The Input stage and the output stage i used is Dataset stage.When i run the job im not at all getting any colored line but in director log details itz showing the error as follows : The file identified as '/home/diff_src.ds' is not an ORCHESTRA...