DSXchange

Hi All,

I am trying to load data into oracle with

Write Method = Load
Write Mode = Truncate

I am getting the following error

"Describe failed because of a missing column for INPUT."


Thanks in Advance

Hi,

How much time is required to load 1GB of data coming in FLAT File and directly to load it into ORACLE Table.

Do we require to drop the Index while we load the Data. Is it a good practice to drop the INDEXES while loading and recreate the INDEXES once the load is complete.

Thanks in Advance

Hi Ray,

There is one more problem, HEADERRECORD or TRAILERRECORD Length varies, it might be of 40 or 45, etc., then how to separate this two records

Hi All, I got a file with continous records written in a single line and there is no space or any other delimeter, but I need to read the data and split the records according to the Length and then need to populate each and every column. Format of the File is as follows HEADERRECORDDETAILRECORDDETAI...

Hi All, I am using EMAIL Notification activity in my Sequences and I am attaching a file to the activity using a parameter. Thing is that I am getting two files as attachments. 1) First attachment is which i required one. 2) Junk attachment which is not required (It is named as ATT2609595.txt) and i...

Hi all, I am having a Tailer record in which I will have a count of the total file and I need to compare this count with Datastage count from Transformer Stage. So which stage should I use to compare both the outputs. Actually I have taken Tail Stage for Trailer Count and for Datastage Count I have ...

ray.wurlod wrote:Yes.

Hi Ray,

Can I know how It can be done

Hi All,

Can we attach Timestamp to a Output File generated by Sequential File Stage.

Is it possible.

Thanks in Advance

ray.wurlod wrote:What stage type are you using for the target?

I am using Sequential File Stage

can you please give a brief discription about your job? And also check if you have given any constraints in the transformer for the number of rows to be processed. Hi Raghavendra, I am not using any constraint in my job I am having a Sequential File which in pipe delimited format and I am moving th...

Hi All,

When I am executing a job I am getting the following error, can anyone help me out.

APT_CombinedOperatorController,0: Job aborting due to row limit being reached on output link: Tgt_Write

Thanxs in Advance

Hi,

I am having a file of length 800, if the record size is above 800 i need to abort the job and go the next file to process.

I would like to know is there any restrictions that a Sequential File will hold only less than 400, as because if the length is 400 it is working fine.

I am sorry, I need ways to project export as in the subject by UNIX command line interface.

Thanks in advance
Vinod N

Hi,

Can we take whole project import by UNIX command line interface.

Thanks in Advance,
Vinod

Hi Krazy,

Your idea is great but can u tell me where is that setting where i can set that row's per transaction to 0 option

Thanks in Advance