DSXchange

Nishant,
Pretty Sure that the number of jobs will not fill up ur 8 - 12 gb of space.

One reason can be Log files but as u said they are gettign merged so should not the casue.

Check out wht Kduke had suggested...

Love,
This repeats every week. Done with the clearing and compilation of the job , which was recommended , and the frst step that I do when this error pops up. But it does not seem to be a perm solution. So need to find a reason for it so that can be fixed for good.
Thanks

Not sure but huge Hashed files??

What about using a Link Merge stage? Of course not directly...but if you put a little thought in it the link merger state should help you out perfectly.

I think your issue is unncessary pipes which are there in your file ans hence the data is not coming in the correct places. Can you open the file in EXL and confirm that the data is not shifted to other columns etc.

You can always have a seperate column defined at the target level rather than declaring at the source level so ur mapping in short will look like -->

Column1 -- Column1
Column2 -- Column2
-- Column3 assigne Column 2

Not aware of any such things. May be you can use Database sync utilities to do such activities and not use a ETL tool to do such things.

Can a pivot stage will help? Our error validation table had the same structure for any validation failure so we used a Pivot stage to populate the table with whtvr validation failed.
I am not sure it will work for you or not but you can give it a thought.

I do not think declaring all the columns as Key is the solution here , but the simplest that I can think of is to declare an extra column in the target and assign it a counter (may be a row counter) - same concept as surrogate key generator. So if your source 1 has 10 and source 2 has 10 rows then t...

The simplest thing that you can do it put some seq file in the process and ppulate it with your dep_date column and and also try subtracting days from it and populate in this file. If it populkates with null theres ur answer that u can not directly subtract days from a date.

Bingo..sorry for the confusion....Yes it was Ken and not Ray.

Duplicate post...

DS Help Files , Search on this forum and plus there is a Article written by Ray on the newsletter of this forum which will help you understand the Hashed File better.

I think you are not defining the Constraints Properly. Also the explanation of which Table gets what data is somewhat not clear. I assume it is Stage table 1 gets data which is in between Dep_datetime - 28 days and Dep_datetime-21 and so on. Also i guess the column Dep_datetime is a date time column...