Search found 2 matches
- Fri Jun 18, 2010 9:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Orchestrate Column doesnt pass in reference query
- Replies: 3
- Views: 2875
Are both GRGR_ID and GRGR_SELL_OVER_DT marked as key columns in the reference link? ... ----------------- Not marked. But should I make it key column? GRGR_ID and GRGR_SELL_OVER_DT is coming from source oracle table and reference is sybase table. Here in sybase I have 4 to 5 tables which each has d...
- Thu Jun 17, 2010 5:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Orchestrate Column doesnt pass in reference query
- Replies: 3
- Views: 2875
Orchestrate Column doesnt pass in reference query
Hi, I have two source. 1 is oracle table with three columns (GRGR_ID,PRPR_ID,GRGR_SELL_OVER_DT). Another one is sybase table. I have to fetch member under the group (GRGR_ID)coming from oracle. I used orchestrate using sparse lookup. The query is like this : GRGR.GRGR_ID= ORCHESTRATE.GRGR_ID And (OR...