DSXchange

Is there a way to generate Tableau Data Extracts directly from DataStage. Informatica seems to have that capability
http://www.tableau.com/about/blog/2014/ ... tion-32815

Wondering if DataStage does. If not, what are our options?

Yep. My doubt stemmed from the behavior of the "after-sql" in the connectors which execute irrespective of whether or not the actual SQL has failed or succeeded and we have no choice there.

Never mind. Found the solution right beneath the drop-down :D

Hi,
Does the After Job Sub-Routine execute irrespective of the status of the job? i.e. does it execute even if the job has aborted?

Thanks Mike! Exactly what I was looking for :D

We're working with parallel jobs. I'm sorry I didn't mention it before. My bad. The issue with sparse lookup is that the DB is hit for each row from the stream - meaning 60000 times for 60000 rows in the stream link. Though the volume on the reference link is definitely 100 times more, I think it ma...

Hi, Scenario - The left link(stream) has 100 records with just 5 keys and the right link(reference) has around 10000 records with 50 keys. I'm looking to do an Inner Join. The data is key partitioned and sorted. Question 1 - Will DataStage bring in all 10000 records into the server? Or will it stop ...

Is there a way by which we can have DataStage extract Excel attachments from email messages? This process is being done manually today. The Excel files are then read using the Unstructured Data stage.

Thank you

Hi Ray, Not being impatient. Waited for a day and found that the post was getting lost in the archives. My apologies if I came across 'pushy'. :) I started breaking the job in parts to determine which stage is causing the issue. Problem is that the the error is so erratic, it occurs once in 3-4 days...

Anyone?

Hi, I've searched extensively but none of the discussions seem to match my case. I keep getting "parallel job reports failure (code 139)" erratically. When I view the performance stats within the designer, the job shows all green though it actually aborted with the error. Here's a snapshot...

Surprised that you get this in DS9. Remember bumping into a similar issue with either the SP stage or the Oracle connector a year back on DS8. A fix pack solved the problem

(1) Depends what is meant by "something". --I meant, is there a stage? I know that there is an aggregator but I have never heard of a sort aggregator. *Sort Aggregator probably refers to the aggregator method. On similar lines, there could be a hash aggregator (2) Yes. There is a differen...

Try replacing ':1' with the ORCHESTRATE.firstcolname reference.

Hi,

Is there a way to change the default port from 31538 to 31539? If yes, how?
Thank you