DSXchange

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
...

Split the source file--> Allow Multiple instance

yes,

Well i created hashed file from source and doing a look up, but i am not getting the expected result.

IF lkp.NOTFOUND THEN scr.no ELSE lkp.no

I created the look up from the source, am i supposed to do that?

Here is the output

No1(key) No2 no3

100~8~T 205 205(changed from '' to 205 aswell) this should not happen
100~9~T 305 205(Changed from 405 to 205)

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...

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...

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...

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...

If i proceed that way i am getting error

job..Oracle_OCI: ORA-00904: "x": invalid identifier

job..Oracle_OCI.DSLink1: DSP.Open GCI $DSP.Open error -100

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 ...

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...

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 "...