DSXchange

hey Thanks!
I got it.. and its working!!

Hi,

We need to calculate 'last day of current month'. Do we have any function or code available? Any direction for this is helpful.

We didn't used any Cast function, because
Select Col1, Col2 from Table1 ---- Works fine
Select Sum(Col1), Col2 from Table1 group by Col2 ---- gives error.

Col1 is decimal (38,2)

We tried with Server Job, it works fine.

Its warning rather, it says, possible loss of data.

Its 9i Oracle.
We have a normal query with few joins. It works fine even with Server Job but throws error in PX.
Core File, we haven't sent it to anybody. What can be seen in this file?

Hi,

We are getting following error in Oracle Stage,

"Contents of Phantom Output File" -->
RT_SC661/OshExecute.sh()20:20944 MemoryFault (Coredump)."

Same query if we run on Direct database through toad, it works fine.
What could be the reason, Cache Memory?

Hi, We are having query with Sum(Col1). When we are trying to fetch records from Oracle Stage its showing warning possible truncation of scale from Decimal (38,10) to Decimal (38,2). We changed column scale to Decimal(38,10) then it gives floating point error. If we select column without any Sum it ...

Thanks for the suggetion.
I am working on this, and it should work.

Thanks guys!
I'll let you know.. once it goes in Build Phase.

Hi, I have following requirement - [Transaformer Stage] (Read Data) -Link- ["File Stage"] (Stored as well as read from it) -Link- [Transformer Stage] I am storing and reading data from "File Stage" simultaneously. Is there any "File Stage" (like Sequential File Stage, L...

if i use 'Stored Proc stage' to call stored procedure using system DSN and pass some parameters to this stored proc.
Does it slows ETL performance in terms of Time?

with performance, I mean time and server utilization.
with heavy, i mean slower ETL server.
if it helps you

Hi,

Calling stored procedure in PX, requires to define System DSN on DS server.
Does it slows performance heavily?

Hi, Can I use 'Generic Stage' as a Transform Stage, where I can set the Operator some Dummy Value ex. 0. (I'll not use it.) The advantage of Generic Stage is, it accepts Two or more Inputs. I'll accept these inputs and perform the processing. But I haven't use it before. Any thought on this Stage?

Hi, The decision I have to make is - for least runtime and saving utilization of resources - based on volumn of Input Volumn and Look up volumn - Source/IP Volumn Lookup Volumn Low Moderate Large Low Direct table Fileset or DT? Fileset or DT? Moderate Large