DSXchange

its working for some records not all, do i need to change anyhting with partitioning property as job runs with 4 node config file..

Thanks.

To get the latest row based on the key columns i am using sort with remove duplicates stage, however its working for some records but not all, also seeing dups. Input--->Sort--->remove Dups--->Output Here is the data.. COL1 COL2 COL3 COL4 COL5 1 02/01/2015 02/28/2015 02/18/2015 01 1 03/01/2015 12/31...

Thanks for your help.

I was trying to design a job to load data into oracle table, before table load i would like to compare the records based on the primary key which consists of 4 keys, if record already exists then log those records into file, if not insert those records. In server job i would have create hash file ba...

I was trying to process only numeric data in a file based on a particular column and track other records with Alpha numeric. i used num(column)=1 to process recrods with numeric data, however when i try to use num(column)<>1 to track records with alphanumeric records, could you please suggest me wha...

Thanks for all replies and I decided to go with server job instead of parallel job.

I compared both input with output, and noticed output file order is different than input file order. DS job is using 4 node config.file which caused this order change. Is there a way to get exact order from input to output without using sort stage as I don't know sort order.

I was trying to read sequential file in the order of the records written in the file but it's not reading in the order.i know we can use sort stage if we know sorted columns.
My question is ..is they a way we can read data in the order of original file with out sort stage in parallel job.

Here are the properties for this field from lookup:
SQL TYPE:CHAR
Extended:unicode
Length:3
Nullable:yes

I am using OR condition so it should work.Anyhow i tried with only ISNull Comparison and it didn't work.

Yes,my lookup failure is continue.
Please advise why IsNull(Col2) is not returning true

My input is Col1 A B Lookup table Col1. Col2 A 1 C 2 D 3 E 4 I need to get Col2 from lookup table based on key column Col1 input Col1 Col2 A 1 B I need to populate ~ for missing Col2 so in transformer stage I use the below code to assign ~ for Col2 If IsNull(Col2) or Trim(Col2)='' Then '~' Else Col2...

i use lookup stage with constraint continue and i thought wherever the condition not met lookup output value coming in as null or empty string so i use the below condition in transformer stage to pass default value '~', But its not working. If IsNull(lookupoutcolumn) OR Trim(lookupoutcolumn) Then '~...

This error actually reported by connector when I enter this SQL in select statement Query field in connector properties.
Thanks.

Not seeing any issue with Query when i execute from sqlplus.

Thanks