DSXchange

kcbland wrote:In the world of computers files have no datatypes. Datatypes are a prejudice used by programs when reading data from .

Thanks Ken

smita

Hi all, I need little suggestion here: I am having the final layout sequential file with 40 columns of which some are with datatypes int,double,varchar etc.But Vendor needs this file as ASCII file with only CHAR as datatype.How should i approach to this?Also i need this particular file again for cre...

alanwms wrote: This explanation is probably hard to follow without code snippets, so I'll work on those snippets for a later post.
Alan

Hi Alan, can you pass on the snippets,so that this group will get the benefit of this.

Thanks
smita

What you mean if 'MO is same for incoming rows '... Do you have any reference data? No there is no reference data.I believe i had not given the proper description: There is a source file with all these fields and i need to load the transformed data in the sequential file. I want the output in the g...

ray.wurlod wrote:Use stage variables to identify the group and the first value of CA in each group, and set a flag if a different CA value is found in the same group. Keep a list of groups and flags, then post-process ...

Can you elaborate it little more.

Thanks
smita

If you are trying to get a Cartesian product then use a Join Stage. or You can use the message handler to suppress the warning from the logs, but in my opinion it is not a best practice or As vmcburney said, remove duplicates from your Lookup stream I dont have any duplicates in the lookup stream,b...

Hi all,

I am having this error message

lkp_group,0: Ignoring duplicate entry at table record 3; no further warnings will be issued for this table

I know that i am getting this error message due to the duplicate entry,but i just want to know is there anyway i can overcome this.


Thanks
smita

Hi, Does anybody had a idea to check the constraint for a group of data? I am having input as: ID MO DA CA 1 0 M COOL 1 0 D COOL 1 0 R FOOL 1 1 M COOL 1 1 D COOL 1 1 R COOL 1 2 D COOL 1 2 R COOL 1 3 D COOL 2 0 M COOL 2 1 R COOL 3 2 M COOL 3 2 R FOOL and so on......... and i need to obtain my output ...

HI all, While loading the data in the seq file i am getting following errors. 1.Sequential_File_57: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. 2.BASIC_Transformer_42,0: Returned timestamp format not recognised for field - ...

Hi Smita, Job Design: Input----->Transformer---->Remove Duplicate----->Output Declare stage variables as follows: StageVar =DSLink3.No StageVar1 =StageVar<> StageVar1 StageVar2 =StageVar StageVar3 =DSLink3.Type:',':DSLink3.Name1:',': DSLink3.Name2 StageVar4 =IF StageVar2=1 then DSLink3.No:',': Stag...

[quote="ray.wurlod" Challenge that decision. [/quote]

If I would have been RAY WURLORD i could had challenged the decision but i am not

Smita

Hi Smita, Can be easily be done using stage variables. You can search the forum and find how to implement this using stage variables. In case you do not find it I will post it by tomorrow morning. Hi amruta, I tried the stage variable but might be you are having some good understanding of this .Ple...

[quote="DSguru2B"]To my understanding: quote] My exact requirement is like this: source: NO TYPE NAME1 NAME2 1 A AA W 1 B BB 1 C CC Y 1 D DD Z Create Temp with metadata like this NO Type1 Type2 Type3 Type4 Type5 Type6 Type7 Type8 Type9 .... 1 A AA W B BB C CC Y .... Thanks smita

DSguru2B wrote:Post what you require to do?

Exactly same way as asked by sengs.


NO ........... TYPE
1 ....................A
1.................... B
1.................... C
1.................... D

At the end my requirement is,
1.........................A,B,C,D

Thanks
smita

kcbland wrote: A mixed bad approach is my recommendation for PX sites. Use the tools appropriate, if it's a shell script, SQL script, Server job, PX job, or blend of those.

I understand that but i am not allowed to use server at the site.

Thanks
smita