DSXchange

When you say capture Data Violation Do you mean you are having lookups which Validate the data or something else. If yes then is it there for all the columns or selective one ?

PDF files? That will be cool. When I saw this I started searching all the Help files about extracting PDF file as I did not know that Folder stage can extract PDF files. I though it was just for XML or CSVs or flat files.

To get the sum you will need to group the fields and the fields which you do not want to group by will have to be first out. You have to tell the aggregator stage if it summed up a column then what it should do with the others - take max of thm or take first of them or take last of them. Same as whe...

Can you explain in a small simple mapping view kind of thing the above requirement like --

Hashed File
|
|
A ---- Trans ------


Because I am now confused , and will like to know why we can not perform the MAX thing.

Thats informative.Any idea how much shuld I let the RT_LOGnnn to grow?.

Depending on this I can archive the Logs in a file and purge all of them once in 7 days may be.

Can not you do this before putting the data in the hashed file ==

Select F1#,F2#,MAX(F3#),MAX(F4#) from A group by F1#,F2#

That way your hashed file will have only one record corresponding to the F! and F2 fields and then you can do the lookup with out any comlex logic.

Hope this makes sense.

My question is how do you import the data with variable columns, if seq.file stage is not the correct one Shilpa. two things you can do -- 1. Import this file in Access and Export it back in a new file with whatever delimiter you want. 2. Or try to use it as a fixed length file. Reading the Rows as...

1. Open the File in a notepad. Remove the Word Wrap.
2. Press Ctrl+G.
3. Go to the line number specified in the Message.
4. Check out if it has 16 columns or not. If yes , check the immediate next or previous line.

:D

Nope, nothing happens at this time on the server.

Is there a tool which tells us what kind of memory is used for different kind of processes in Datastage. My processes is frozen and i need to find out is it because the processes were kicked out of the memory usage?? and why did this happen?

Well when you say point of" Failure" , I can not say there is any. It randomly Freezes in any of the process and at any point. The last Log which is show off in the job which keeps on saying "running" is cleared Job logs.

We have master sequence activities which call another set of sub master sequence activities and these sub master sequence activities call the jobs. The problem that we are facing from thelast 2 months is that the jobs froze (not the same but different places). Previously we had this probelm once in ...

The safets way to handle any date columns is to do what Kris mentioned above. Declare the Column in the stage and then say generated SQL. Copy whatever the stage is doing with the timestamp column and paste it is your USRDFN query.

Nothing else in the job? Without that we can not assume that this stage is the probelm or some other...

Can you rename the file and run the job again? I have a feeling that your permission while viewing data or running the job is messed up...