DSXchange

Hi,

As per design standards, we keep IPC stage between 2 passive stages,

This improves performance.Why can't we go for transformer stage, what

is the advantage in choosing IPC stage over transformer stage
between 2 passive stages.

cheers;
saama

Hi,

plz can you specify what type of join are supported by lookup and merge stages.

cheers;
Saama

Hi Gurus,

Does lookup and merge support all types of joins. what i mean to say is that can we do inner, left, right and full outer join with merge and lookup stages.

cheers,
Saama

Hi Gurus,
Thanks Very much.

I will mark this topic as resolved.

cheers;
Saama

Hi Gurus,

where should I provide in sequential file stage.I mean in which tab or which property i should provide.

cheers;
saama

Hi Gurus,
I have given incomplete information.one of my input column has NULLS in it.

One of my input column simply looks in this fashion.
created by
NULLS
NULLS
NULLS

Due to this my lookup fails.
Field "UPDATED_DATE" is null but no null export handling is defined.

cheers;
Saama

Hi Gurus, My design is odbc------------->lookup---->sequential file. Iam using 2 odbc stages followed by lookup stage and then sequential file stage. Iam getting the below error. Sequential_File_6,0: Field "UPDATED_DATE" is null but no null export handling is defined. In sequential file I ...

Hi,

Join supports all types of joins like inner join, outer join and full outer join.

what about merge and lookup.Does they support all types of join.

CanGurus help me out.


cheers;
Dileep

Hi Gurus,

I have never built a subroutine.
Can anyone plz help me with the basics.Like i want to know where can we built subroutine.I mean which component of datastage. can any one specify the icon in manager where i can built routine.

cheers;
Saama

Hi Gurus,
Thanks very much.But what abt the dsexecute() function.

Why is this used.In what way is this useful in scheduling the jobs.

Can anyone help me out.

cheers;
Saama

Hi Gurus,

I have never done scheduling, can any one help me out with the steps involved in scheduling datastage jobs using unix utilities like corn tab utility.

cheers;
Saama

Hi, Is there any way to find the table used in datastage jobs (ie) I want to find the dependent analysis. One of the way is usage analysis, by which dependency analysis can be found. Another way is by generating report using designer. Is there any other way to find the dependency analysis . cheers; ...

Hi Gurus, when are the OCI LOAD and MSSQLSERVER LOAD stage used in the datawarehousing. At what stage are these stages used in datawarehousing sense. I know that OCI and MSSQLSERVERLOAD disables the constrainsts and indexes , doesn't check for integrity of data and load the data. Both deal with sepa...

Hi Gurus,

what is the best practice in datawarehousing, what is maximum amount of data that a source stage can handle in parallel version.

we break the data in chucks and handle it separetly.

what are the maximum columns or rows that .

please help me in analyzing.

cheers;
saama

Hi Gurus,

can we invoke the functions like DSGetJobInfo from the command prompt.
But these are functions, can we call these functions from command prompt or else these functions are used only in processing stages.

cheers;
saama