yes,
Step 1:
source -->Link_Partitioner-->source1,source 2...
Step 2:
Source1 -->Transformer(your logic) ---> Target table ( Allow Multiple Instance)
Source2 -->Transformer(your logic) ---> Target table
...
Search found 102 matches
- Tue Jun 02, 2009 11:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job optimization
- Replies: 8
- Views: 4039
- Mon Jun 01, 2009 2:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job optimization
- Replies: 8
- Views: 4039
- Thu Jan 29, 2009 12:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not matching
- Replies: 15
- Views: 7015
- Thu Jan 29, 2009 9:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not matching
- Replies: 15
- Views: 7015
- Thu Jan 29, 2009 8:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not matching
- Replies: 15
- Views: 7015
- Wed Jan 28, 2009 8:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not matching
- Replies: 15
- Views: 7015
- Tue Jan 27, 2009 8:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not matching
- Replies: 15
- Views: 7015
- Mon Jan 26, 2009 2:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not matching
- Replies: 15
- Views: 7015
When i find a match on 100~8~T then i need to use value in no2 column i.e 205 and drop it in no3 column of 100~9~t(cross reference) No1(key) No2 no3 100~8~T 205 100~9~T 305 405 Noa(Key) Nob(Key) Noc(Key) No2 no3 100 8 T 205 100 9 T 305 405 o/p No1(key) No2 no3 100~8~T 205 100~9~T 305 205(Changed fro...
- Mon Jan 26, 2009 11:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup not matching
- Replies: 15
- Views: 7015
Lookup not matching
I have a source Hashed file ex: No1(key) No2 no3 100~8~T 205 100~9~T 305 405 I need to perform a look up against the same hashed file. So i created a new hashed file from the source and split the key into Noa(Key) Nob(Key) Noc(Key) No2 no3 100 8 T 205 100 9 T 305 405 Now i am performing a lookup. wh...
- Fri Nov 14, 2008 1:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: update a database table
- Replies: 23
- Views: 11333
Table1.id in ( select id from Table2 where Table2.no =:1) step1: I have changed the design to implement subquery in a separate job step2: I am able to get the id for Table2 step3: Now from the lookup i draged and droped on the key column of the Table1 step4:(modified) UPDATE TABLE1 SET DT=TO_DATE(:2...
- Fri Nov 14, 2008 11:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: update a database table
- Replies: 23
- Views: 11333
COLUMN NAME COLUMN1 KEY DT ID1 ID2 ID3 ID4 NAME1 NAME2 NAME3 NAME4 NAME5 NAME6 UPDATE TABLE1 SET DT=TO_DATE(:2, 'YYYY-MM-DD H24:MI:SS'), ID1=:3, ID2=:4, ID3=:5, ID4=:6, NAME1=:7, NAME2=:8, NAME3=:9, NAME4=:10, NAME5=:11, NAME6=:12, WHERE ID4 = 'XYZ'AND NAME1 IS NULL AND Table1.id in ( select id from...
- Fri Nov 14, 2008 11:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: update a database table
- Replies: 23
- Views: 11333
- Fri Nov 14, 2008 8:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: update a database table
- Replies: 23
- Views: 11333
job design txtfile--->trm-->oracle(i have to update this table) User defined sql: UPDATE Table_name SET column3=:1, column4=:2, column5=:3, column6=:4, column7='abc' WHERE column7 !='xyz' and column3 is NULL Table_name.id in ( select id from Table_name2 where Table_name2.no =:additional column from ...
- Thu Nov 13, 2008 2:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: update a database table
- Replies: 23
- Views: 11333
I am working on it will let you know I did that, but the problem is it does not belong to this table( i guess that's the problem, How should i handle it) UPDATE Table_name SET column3=:1, column4=:2, column5=:3, column6=:4, column7='abc' column8=:8 WHERE column7 !='xyz' and column3 is NULL and Table...
- Thu Nov 13, 2008 2:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: update a database table
- Replies: 23
- Views: 11333
Let me back up The problem is arising just because of Table_name.id in ( select id from Table_name2 where Table_name2.no =:8) 1. column 8 is coming from a txt file, from which i need to to find a match against a database table. What? That's an important piece of information you left out. Which "...