DSXchange

Hi All, We are Developing the Make_SubRecord job given in Examples (From PageNo 42-3 to 45-6) in Chapter-42 of DataStageParallelDeveloper job Document. InputData------------->MakeSubrecordStage-------------->OutputData (DataSetFile) (DataSetFile) 1)While viewing the data in OutputFile, It is appeari...

Thanks Ray

Hi Beeram,

This is an answere to Don't Sort(Previously Sorted) option.
I am looking for an ans to Don't Sort(Previously Grouped) option.

Thanks
Prashant

Hi all,

In sort Stage->Properties->Sorting keys

Wht is the meaning of Don't sort(Previously Grouped)?

Is it to do with Data Partitioning or Group by at SQL level?

Can any body explain how to use it?

Thanks
Prashant

Hi, When i am running my jog getting following as a fatal error and subequently job is eborted. x2AccountMaintenance. (fatal error from ): Error executing phantom command => Cannot open file "&PH&". If you need more detail please let me know. Can any body guide me? Thanks Prashant

HI All, I am loading the fact_table . At one place before transformation we have used Pivot stage. while running the job after loading around 1 lac records to fact table ,its giving following error and susequently aborting the job. Abnormal termination of stage FCT_TRNEBL1_7_TEST..Pivot detected Job...

Hi All, When i am coming across the compiletime error as "Job contains cyclic or linear dependencies and will not run. Thro' show error , it is highliting the transformer stage . I have cheched all the things ,but still error is persisting. Can any body help me to troubleshoot it. Thanks Prashant

Hi All

I am exploring the functionalities of Sort.

In Sort -> Stage -> Properties ->

Can any body explain the What is Collating Sequence maps thro any example?

AS its not clear thro' help material.

Thanks

Prashant

Thanks Amos and Bhibhu for giving insight into the matter. Regards Prashant Hi, Round-robin will give you an even distribution. Random will give you an even distribution as well but the distribution will not be deterministic. Hash - the distribution will not be even but equal keys will be placed und...

Hi All

I am exploring the functionalities of Sort.

In Sort -> Stage -> Properties ->

Can any body explain the What is Collating Sequence maps thro any example?

AS its not clear thro' help material.

Thanks

Prashant

Thanks to all of you for sharing the useful information.

Regards
Prashant

Hi All, I am exploring all the fuctionalities of Sort Stage in datastage Server mode. In Sort -> Stage ->Properties -> I am not able to understand following options and its use.............. 1)Max Rows in Virtual 2)Temporary Directories 3)Escape Character 4)Tracing Level 5)Stable Sort 6)Column seper...

Hi All,

How does the Link Partitioner work and what for is it used.
I have gone through the documention but it is very brief and not able to understand how to use this stage.

Can any body explain it with a example ?


thanks,
Prashant