DSXchange

Why do you need decimal(39,12) ? I think decimal(38,10) is enough to hold the sum or count.

Use "To_date(policy_eff_dt, 'YYYY:MM:DD HH24:MI:SS') POLICY_EFF_DT " in your query.

dfloat is the internal data type for decimal(38,10) same as BigInt (15) --> int64.

Since your first constraint is linkStatsXML.FileType = "FULL" your result may be random, means nowhere in your job you ensure atleast one record with linkStatsXML.FileType = "FULL" should be there in the node 0.

I think this is an issue of your "third party plugin" (if you consider this is an issue). Did you check it in your output/target rows? It may use the upsert (if your target is a database), instead of insert it updates the row according to the key. Since you get 1000 rows in your seq file, ...

Did your command stage create file name list with the delimeter after the last file name?

Are you using any sorting logic in the transformer or funnel? Why its using memory. Please tell us little bit detail of your design.

Are you using any sorting logic in the transformer or funnel? Why its using memory. Please tell us little bit detail of your design.

You can use IsValid function in transformer to see whether is it a valid number or not. If not try to assign a default value. If you are using oracle TO_NUMBER, use NVL(TO_NUMBER(TRIM(Field)),<default value>.

Please tell us about your input and expected ouput with a simple example....

What is the difference between A and B date logic. These are same in input but your expected output contain one row from A and two row from B...

No,
This should be ls -m *.csv.

What is the data type defined in oracle for this field?

Yes you can.

Yes, you cannot use the encrypted parameter in a shared container.
If you explain your requirement, you may get some way around of it.