DSXchange

there is a SCD stage in the version 8 which supports type 1 and type 2 SCD

where did u execute this query ? this needs to be done in the DS shell

did u setup the home and lib path correctly?

thanks to ray for this

its seems like the nutcracker is going nuts :D.. not installed properly ?

its seems like the nutcracker is going nuts :D.. not installed properly ?

Why dont you split the records and feed each column into a aggregator and then get row count for each. and then merge them at the end with the row count??

i just imported the metadata of the file and viewed it. its working ok . you can try this and see what metadata type is assgined when you do it. If you have integer values you need to handle the nulls yourself and use the field max width property for such columns

do the null handling for these fields in the column metadata

view->> customise pallet-> stage types-> parallel -> processing-> basic transformer.

there is a schema reconciliation option in the connector stage. try setting it to ignore......

this is more or less the same

viewtopic.php?p=305786#305786

Error when checking operator: Key field "cust_acct_id" was not found in the view-adapted input schema [keygroup/keygroup.C:985]

can't say much without knowing what the next stage in the job design is?

i guess you can split the job into two one for insert and one for export and then handle this in the sequence? or write a trigger ??