DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 262 matches
Author Message
 Topic: Automate loading flat files
UCDI

Replies: 8
Views: 224

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 11, 2017 11:53 am   Subject: Automate loading flat files
I think IA can do this sort of, and I think IA can read files instead of databases, but not 100% sure as I don't use IA.

It would be fairly trivial to do this in an external program.
I mean, th ...
 Topic: Automate loading flat files
UCDI

Replies: 8
Views: 224

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 11, 2017 8:42 am   Subject: Automate loading flat files
what DO you have? Does the flat file schema match a target or other database that has meta-data you could import?

if it matches the target you can export the target table def and use your perl or ...
 Topic: Decimal value is out of range
UCDI

Replies: 6
Views: 607

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 09, 2017 12:08 pm   Subject: Decimal value is out of range
just bits ...
-1, if dumped without any logic into unsigned int, will give the maximum value of that int.

That is if you put -1 into an unsigned byte without any error checks you get 255, and if ...
Workaround Reported
 Topic: How to validate a string of code
UCDI

Replies: 11
Views: 4224

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 09, 2017 11:28 am   Subject: How to validate a string of code
I think what it comes down to is that 'rapid' is subjective. I can write a C++ or basic routine to do advanced string processing in a couple of min and have it debugged and delivered inside an hour ( ...
Resolved
 Topic: manage lookup table by datastage
UCDI

Replies: 9
Views: 197

PostForum: General   Posted: Thu Oct 05, 2017 9:17 am   Subject: manage lookup table by datastage
or directly from a dataset / file. But you don't need both, either a file or a table.
Workaround Reported
 Topic: How to validate a string of code
UCDI

Replies: 11
Views: 4224

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 05, 2017 9:15 am   Subject: How to validate a string of code
if it becomes too complicated to do in a transformer with string functions and you don't want to fight regular expressions you can also write a basic routine (or if you want to go external, any langua ...
 Topic: XML Input document parsing failed. Reason: Xalan fatal error
UCDI

Replies: 1
Views: 137

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 29, 2017 9:15 am   Subject: XML Input document parsing failed. Reason: Xalan fatal error
figure out this:

The process cannot access the file 'C:\Inetpub\wwwroot\TMSService\logs\SDCAIPATH.txt' because it is being used by another process."/>

The file is being lock ...
Resolved
 Topic: XML Error Handling on incomplete file
UCDI

Replies: 11
Views: 392

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 29, 2017 9:08 am   Subject: XML Error Handling on incomplete file
I have found the keep it local approach to be the best for that.
So what we do is drop the file to an intermediate folder from the network then do a unix move command once that is complete to the co ...
 Topic: glibc detected
UCDI

Replies: 17
Views: 597

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Sep 28, 2017 9:36 am   Subject: glibc detected
This is one of 2 things.
Either you pulled in too much data and ran your system out of memory, or you need your IBM tool suite administrator person/team to look at it.

Stepping away from a probl ...
 Topic: validate Longitude and Latitude
UCDI

Replies: 6
Views: 275

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 22, 2017 1:30 pm   Subject: validate Longitude and Latitude
its your data, but be sure the entry is not valid if you cap it back to the desired range. That is, 250 degrees is a valid location on the earth, and you can convert it to a negative degree value to ...
 Topic: Metadata from sql
UCDI

Replies: 3
Views: 350

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Sep 22, 2017 12:51 pm   Subject: Metadata from sql
while the correct thing to do is import the metadata, this will help you for intermediate jobs where the metadata isnt in any database.

you can write a dataset from where-ever in your job and impor ...
 Topic: Blocked by the DoD
UCDI

Replies: 5
Views: 188

PostForum: Site/Forum   Posted: Thu Sep 21, 2017 9:25 am   Subject: Blocked by the DoD
I used to work for DOD. We had a couple of machines that were not certified and did not touch our networks etc for getting on the web and looking stuff up, and the certified machines that were locked ...
Resolved
 Topic: Passing and Calulating Expression Dynamically
UCDI

Replies: 5
Views: 352

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 13, 2017 2:08 pm   Subject: Passing and Calulating Expression Dynamically
can you add a table to your database so you could look it up in whole or part? For example if each client has a static piece and the rest of the derivation is more consistent?
 Topic: Unicode with RCP?
UCDI

Replies: 11
Views: 539

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 11, 2017 12:10 pm   Subject: Unicode with RCP?
What exactly is the error?

Assuming its string and not uc in the source, string and not uc in the flow, and at most uc on the target side .... but datastage should be able to write string source ...
 Topic: Datastage vs. Alteryx: Comparative Pros & Cons
UCDI

Replies: 8
Views: 370

PostForum: General   Posted: Fri Sep 08, 2017 8:13 am   Subject: Datastage vs. Alteryx: Comparative Pros & Cons
usually modern UI means slower and in a browser that ignores standard keyboard shortcuts and lacks a right and middle click interface. Browser UI are largely poorish, though the industry seems bent o ...
 

 Jump to:   



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