DSXchange

Yes, I am pretty sure that numbers are stored as text (they are aligned to left), as I mentioned before because of the nature of my input data, I couldn't make it possible to declare both varchar fields and decimal fields as it was, to support both of them I had to define them as varchar :? Thanks f...

Let me clear. I didn't even try to use RCP, because as far I read about it, it makes you to select a complete schema of the file at run time. What I need is, writing a column into a file (using unstructured data stage) which can be either decimal or varchar based on the input data selectively. (Beca...

Hi, Hope I won't be repetitive for asking. What I am trying to build a parallel job which is reading a sequential file, sorting its data and then writing it to an unstructured data (into an excel file). My excel format of the data is not fixed length and includes both decimal and varchar data types....