DSXchange

Try in this way: ------------------------ Declare Date fiields as Varchar type, Then go to columns tab click on the serial no tab of column,there u have three categories 1)Field lavel2)String Type 3)Nullable under Nullable -----set Null Field value=Null under String type----set Default=0 (some value...

Declare that column in source stage as varchar then use StringtoDate() Function in Transformer Stage,then u get O/P as date value.


Regards
Thiru

Hello Friends.... Regarding Sivas's question.....I mean that if the ITEM_TYPE is either C 0r D then the sequence starts from 1400...similarly with ITEM_TYPE is either 2 or 3 then the sequence starts from 2500.... I tried using the routine KeyMgmtNextconcurrentValue()...it initialized correctly but i...

A configuration table SHOWING THE LIMITS WAS given ... ITEM_TYPE - Start - End A - 1000 - 1299- B - 1300 - 1399- C - 1400- 1799- D - 1400- 1799- E - 1800- 1999- F - 1800- 1999- G - 1800- 1999- H - 1800- 1999-- 1 - 2000- 1999- 2 - 2500- 1999- 3 - 2500- 1999- BASED ON THE ( ITEM_TYPE ), A SEQUENTIAL N...

There is no limit of Lookups in a job we used more than that u specifed number.


Regards
Beeram

If you go for a sinlgle node for each project then how u'll achieve parallelism.



Beeram

To only add new columns Column Generator is suitable.
But to add new column with derivation Transformer stage is suitable.
Using modifgy stage we can drop or Keep columns,Type_Conversions and Null Handlings.

Ex:to handle nulls:
col1=Handle_Null(col1,0)


Regards
Beeram

I am doing sum on Quanity column(Using Aggregater Stage),output must be integer type,so how to get integer value after Aggregation?
Any ideas....

Regards
Beeram

Hi Vijay,

thanks for ur reply,

Can you give clear details again,bcaz as you said i followed but i didnt get solution.

Regards
Beeram

using Parallel Jobs,
How to remove Column Header in Sequential File Stage ?

Any ideas------

Regards
Beeram

Hi,
we can do while encrypting the server job in a Shared Container then we can call that into PX.


Regards
beeram

Define that column as key column then try.


Regards
Beeram

Hi,

If the input records already sorted by this column set SORT MODE=Don't sort, if records are not sorted already on this column use SORT MODE=Sort


Regards
Beeram

Cant you declare TRAN_ITEM_SEQ_I as Key field ?
Also tell which join ur using?


Regards
Beeram

Hi,

In Transformer Stage select Preserve partition type as Set and also change the execution mode then try.

Regards
Thirupathi Reddy