DSXchange

Transfomer is dropping a record when the field has null. DB --> Xfm-->Lookup-->xfm2..>file Source has 15 rows. One of the columns in source doesn't have lookup value in lookup table. so it is passed out of Lookup stage.(15 rows) with NULL value. When data passing out of xfm2, only 14 rows are passed...

Thank you Ray. ORDER_ID GROUND AIR EXPRESS PRIORTY 1 None No No Yes 2 Yes None No Yes When I run the job, data displays as ORDER ID GROUND AIR EXPRESS PRIORTY 1 None No No Yes 1 None No No Yes 1 None No No Yes 1 None No No Yes 2 Yes None No Yes 2 Yes None No Yes 2 Yes None No Yes 2 Yes None No Yes I...

Data is in source as below and needed to be loaded into target as specified. I thought of pivot stage. Couldyou asuugest any ideas? Source: ======= ORDER ID GROUND AIR EXPRESS PRIORTY 1 None No No Yes 2 Yes None No Yes Target: ====== ORDER ID Ship Desc 1 GROUND None 1 AIR No 1 EXPRESS No 1 PRIORTY Y...

Partition: Auto, added key: id
Result:
"0","2","E01","2","E01"
"1","4","E03","5","E01"
"1","6","W05","6","E01"

But ids 1,3,5 are skipped.

Table #1 --------- id(Int) Order(Varchar) 1 NULL 2 E01 3 E02 4 E03 5 E04 6 W05 Table #2 --------- id(int) Order2(varchar) 1 NULL 2 E01 3 E03 4 E03 5 E01 6 E01 Table#2 | Table#1 ----> Compare Stage -----> SeqFile As Row#3, 5 and 6 are different, output for Result field should be 1, -1, 1. But I am ge...