DSXchange

xcasals wrote: I'm trying to ignore the duplicated rows from an input.

If your input data is from a relational database, you can actually add the DISTINCT clause in your DML (i.e. SELECT query). You remove unnecessary steps this way.

Hi, I am a Informatica guy, .... where do i need to give this condition? Thanks The link given to you by Rich should be enough to explain how to create and use hash files in DataStage. What I would like to point out is the equivalent of the "Condition" tab (of Infa Lookup Transformation) ...

victor, if i remember it correctly, there's no line continuation character in DS Basic (search this forum; it's been discussed before) so that if your condition becomes too long, you'll just have to logically split them into either 1. a nested if, or if condition1 and condition2 then ... end else if...

your error msg means that Oracle is detecting a LONG datatype string when you insert the value into your target field. this is not allowed in Oracle. VARCHAR2 datatype can accept 4000 bytes max while LONG datatype can accept up to 2GB. do you concatenate anything to your string input so that it exce...

roy, the only time i encountered this problem was when the userid i used had no SELECT privilege on the table... but your userid is the table owner so it's very strange :?: anyway, just in case you've overlooked it, can you confirm that your userid can SELECT the data in your table? and, are you imp...

if i may add...

7. most, if not all, of the bug-fixes (patches) done for v4.x were added into v6.x. Most notably, the memory-leak problems with OraOCI and Aggregator stages.

vladimir

This is on the AIX version of DS... If I remember it correctly, v4.x and below used to call the rpc daemon/engine as uvrpc which subsequently became dsrpc from v5 onwards. I thought my friend, Felix (he did the installation/upgrade) mentioned that we can actually use v4.2 and 6.0 because of the diff...

Victor,

Please see the discussions in this link...
viewtopic.php?t=85420

cheers,
vladimir

Hi there. I would like to know how can I use a PIVOT stage. I didn't find any information on the help manuals. Thanks in advance :D hi, briefly, the Pivot stage is simply a one-way "transpose" stage - used for transposing your columns into rows only. you can't use it to transpose rows int...

if all this things are bad with Informatica. How come they have the largest base of customers. AFAIK, there's no Informatica client yet in Thailand :o Look no tool is the perfect tool... Agree... I have always thought that the "Learning Curve" is 90% borne by the "Learner" and 1...

indulge me to add a few things to satisfy Rajeev's curiosity... 1. Informatica doesn't support milliseconds - if you are using time to establish uniqueness then you can't do it with this tool... unless you write a special script... :( 2. Informatica performs well with simple, direct source-to-target...

hi louise, you can't place a conditional statement (to filter the null inputs) inside the derivation column in the output tab. you can't add a constraint in this stage either. you need to let your output go through a Transformer stage and add a constraint to filter out the null output in BB. hth, vl...

Guillermo amigo, You need to see if the job is still active or not. One way to do it is check if it's still writing log info into the RT_STATUSnn, where nn is the job number, files. If not, no amount of clicking of the Stop button will change the Job Status in the Director window. What you need to d...

It sounds like a memory-leak problem on the OCI stage. The OCI8 plugin used to have this problem in DS4.2. in AIX, you can use the ps v command to monitor it... but I don't know its equivalent in Solaris... It would be easier to diagnose though if we see your job design... but whatever it is, strang...

quote: Originally posted by Peytot [br]Hi, Our DataStage job performance propertied are set to : - Enable Row Buffer, Inter process - Buffer size set to 128Kb - Timeout set to 45 seconds Pey Pey, In my experience, it is usually caused by Inter Process Row Buffering and Enabling the pre-pload to memo...