DSXchange

I was able to resolve the issue using Oracle8i stage but I opted for hash files for the lookups instead due to performance. As long as I had the bind parameters correct. Thank you all for your assistance. Have a great day.
Judy :D

Judy, what are you trying to do? Do you want n-output rows or 1 output row per input row on your lookups? Here it is...... Source table has SOURCE_ID - ABC and DEF Lookup table has SOURCE_ID 1 SOURCE_DESC "ABC", SOURCE_ID 2 SOURCE_DESC "DEF" If source.SOURCE_ID = lookup.SOURCE_DESC then return look...

Source table has SOURCE_ID - ABC and DEF Lookup table has SOURCE_ID 1 SOURCE_DESC "ABC", SOURCE_ID 2 SOURCE_DESC "DEF" If source.SOURCE_ID = lookup.SOURCE_DESC then return lookup.SOURCE_ID It should one source_id per record but DS is only finding the 1st record in the table & writing it to all r...

I've been tasked with writing ETL server jobs using 1 source table & 3 lookup tables. I'm getting multiple results & DS is writing the 1st record to all fields in the output. My limited previous experience was with 6.0. Does the logic go in the transform stage under constraints or in the Aft...

Extended Application Architecture Facilities (EAA). My understanding is the copybooks are dynamically created when the job is run. If this is the case for DAGs - how do I import the copybook to use as a DS table definition? With my other source systems I am using Complex Flat File stages - will this...

I'm trying to import using Universal Command MVS flat files by using Data Stage 7.5. I'm not sure which stage to use for this so I can put the UC JCL script in it. Is this possible? I have imported the Cobol copybooks but I'm trying to bring the MVS files in & load them as Complex flat files int...