DSXchange

Thank you guys for all the answers.I checked the Manager.I tried exporting one of jobs when i clicked on Job designs it said

"Unable to return an attached job."

So design time information is in the exported jobs.
Thanks once again for your responses.

I guess it depends on what you consider 'useful'. You should at least have found out what it means and how you typically get there - it can either be a purposeful thing because you've only promoted released jobs or just the executables. If they were 'fine' before and suddenly started giving you thi...

I am trying to open jobs in my project but getting the error

"This item has no design time information".

I tried searching for this topic but could not get anything useful. Could you help me resolve this issue links related to this topic will also do.Thanks in advance.

There is no specific truncate command in db2.
You can use following command in unix script.
Call that script in the before-job sub routine.

Did u search for ' sparse lookup ' ? This topic has been disscussed many times before.

Make sure that new column (ID) is an integer one.

Yes.Deifine the required field lets say as ID in the Column Generator Stage.In the OutPut page of this stage go to 'Edit Column Meta Data Box' by right clicking ID column and selecting 'Edit Row' option.Now in the 'Properties' option select 'Generator' box.Set 'Type=Cycle', Initial Value=1,Increamen...

Absolutely.
Use 'Cycle' method.
Set Intial Value=1
Increament by = 0

Try using 0X20[space] instead of 0X0.

Hi, i didnt understand= 'Specifically you do not include the name of the key column in your design.' Am i not supposed to add my key column (The one i am doing NEXTVAL with ) in the columns property of my DB2 stage? It means INSERT INTO schema name .Table name ( col1,col2 ) VALUES ( NEXTVAL FOR sch...

I think instead of partitioning all 200mn rows in one go if we could partition those in chunks could resolve the space issue as 200mn rows worth space wont be required.Not sure on this.

Partition on 3 keys can be done on input links to funnel.Then Sort will have same partition method.


Regards,
Tejas

Hows the configuration file like ?
May be we can dedicate one node to sorting functionality alone.

Regards,
Tejas

What's the exact error mesage you are getting ?

thumati.praveen wrote:When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same

Are you able to open that job in the designer ?