DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 177 matches
Author Message
Resolved
 Topic: Hashed Pre-Load: both DATA.30 and OVER.30?
datastage

Replies: 2
Views: 1694

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Aug 06, 2013 8:26 am   Subject: Hashed Pre-Load: both DATA.30 and OVER.30?
DataStage® Release: 8x
Job Type: Server
OS: Unix
When a hashed file is pre-loaded to memory, is just the DATA.30 loaded or is the OVER.30 included as well?
 Topic: More than 9 active oracle connections in a datastage job
datastage

Replies: 1
Views: 2000

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 15, 2010 2:28 pm   Subject: Re: More than 9 active oracle connections in a datastage job

2. Also, could anyone suggest the pros and cons of placing all the extracts in a single job as against having 10 ETLs, one for each entity?


The only pro I can think of in a design like this is ...
 Topic: Type 30 Descriptor Table Full - Windows
datastage

Replies: 5
Views: 2887

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jul 24, 2007 3:19 pm   Subject: Type 30 Descriptor Table Full - Windows
If you don't believe that you are using that many hashed files, remember that most of the Repository tables are also hashed files. Every job you create engenders some more, such as RT_CONFIGnn, RT_ST ...
 Topic: fact table
datastage

Replies: 9
Views: 12965

PostForum: Data Integration   Posted: Wed Dec 28, 2005 1:02 pm   Subject: fact table
I have seen factless facts used mostly to report on all salesmen regardless if they have sales or some simliar concept. This way you can see the salesman has no sales for a given time period and the r ...
 Topic: Ignoring Duplicates while reading from Seq File
datastage

Replies: 13
Views: 5076

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Dec 28, 2005 12:52 pm   Subject: Ignoring Duplicates while reading from Seq File
I agree with this, and that there is no need to go to a database table here. Obviously the RowProcCompareWithPreviousValue method worked for you, and I also think the other idea involving sorting and ...
 Topic: How would you like to see the DSXchange cover its costs?
datastage

Replies: 15
Views: 11514

PostForum: Site/Forum   Posted: Mon Jan 10, 2005 3:28 pm   Subject: How would you like to see the DSXchange cover its costs?
Dan Marshall said that the site's most valuable asset is the people who collaborate here. This is definitlely true. The ability of the community to help you resolve your problem in a few hours is ce ...
 Topic: performance issue
datastage

Replies: 8
Views: 3497

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Jan 10, 2005 9:43 am   Subject: performance issue
also, tell us what the job is doing in terms of row buffering, and if row buffering is on whether it is In-process or Inter-process. Or at least run the job with different settings in regards to row ...
 Topic: Excel sheet
datastage

Replies: 2
Views: 1650

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Jan 10, 2005 9:26 am   Subject: Excel sheet
Sidenote: The Excel question is probably another good candidate to add to our FAQ section.
 Topic: Version Control and number of jobs in a project
datastage

Replies: 3
Views: 1601

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Jan 10, 2005 9:12 am   Subject: Version Control and number of jobs in a project
I've seen a VERSION project as big as 5200 components and am working with one now that has 2300 components (mostly jobs) and it still performs fine.

A common best practice though appears to be on ...
 Topic: How would you like to see the DSXchange cover its costs?
datastage

Replies: 15
Views: 11514

PostForum: Site/Forum   Posted: Fri Jan 07, 2005 11:32 am   Subject: How would you like to see the DSXchange cover its costs?
thoughts:

1) it certainly weren't hurt to have a donation jar (Paypal, or similar) regardless of the final decision, hopefuly those that use the forum frequently wouldn't mind donating a little, e ...
 Topic: Project Directory Growing Big
datastage

Replies: 10
Views: 4454

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Jan 06, 2005 8:12 am   Subject: Project Directory Growing Big
You also need to get your data and intermediate files out of the project directory and into a dedicated data directory. Are you using the localhost account to store your hash files? Are you writing ...
 Topic: Project Directory Growing Big
datastage

Replies: 10
Views: 4454

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Jan 06, 2005 8:05 am   Subject: Re: Project Directory Growing Big
A hint: backup your project. Delete the jobs, reimport them and reschedule them (if that's required for a development environment). The problem you're probably having is that the project log hash file ...
 Topic: Mapping new drieve
datastage

Replies: 8
Views: 2997

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jan 05, 2005 3:22 pm   Subject: Mapping new drieve
Is this how the coding should look?

Does it matter that part of the path has a space "FTP TOTE" instead of "FTPTOTE"?

Call DSExecute("NT", "net use K: \\Secureftp\FTP TOTE /PERSISTENT:NO", msgs, ...
 Topic: job control hard coded
datastage

Replies: 3
Views: 3151

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jan 05, 2005 1:38 pm   Subject: job control hard coded

If it fails it calls DSLogFatal and Logs a fatal error message (“Job Attach Failed: SAPimportParentDIST”) in a job's log file and aborts the job


The DSLogFatal lines in the posted control are ...
 Topic: job control hard coded
datastage

Replies: 3
Views: 3151

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jan 05, 2005 12:57 pm   Subject: job control hard coded
I think your question is a little vague or hard to understand exactly what you want to know... please rephrase and clarify.

I'm wondering if you are looking at the control logic here and are curiou ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours