DSXchange

Hi meena,

Iam not using any oracle stages. Actually Iam generating seq of numbers and writing to a file. Iam getting a date from flat file and Iam grouping by date and generating a surrogate key for that group and loading that number like DMT1,DMT2,........DMt79 to seq file.



Thanks,
Somaraju

Hi, Iam generating a keys using surrogate key . My actual requirement is Ex: If Iam running the same job twice then I have to generate keys for first run as 1......70 . Its working fine. But If I want to run the job for second time with different file I want to generate key starting with 71.....so o...

Hi Kumar,

Thanks for your replys. They are really helping me to solve my problems .Can I use select distinct columm1,columm2 from table. so that I can over come this problem.


Thanks,
Somaraju

Hi,

When Iam running a job which has lookup stage that is looking to db2 table. Iam getting a warning . Please help me in getting out of this warning.

warning message:

Lookup,0: Ignoring duplicate entry at table record 5,216; no further warnings will be issued for this table


Thanks,
Somaraju

Hi, Please help me . I want to aggregate records on this condition Group by : Currency and my problem is actually how to find sum(price) and count (Material). When Iam selecting Aggregation Type = Count Rows. Iam not able to select Aggregatio type = calculation for Sum(price). How to achieve sum and...

Hi, Please help me when Iam validating a job. Iam facing a Fatal Error main_program: Syntax error: Error in "group" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Error in binding: Expected '=', got: "$", line 123 I have a job. Iam usi...

Hi Sanjay,

I dont want to aggregate any thing . I want to lookup DB2 table with Hash file.
How can I do this by using hash file in server shared containeer. If I got you wrong please correct me







Thanks,
Somaraju

Hi Ray, Iam want to Use Hash File inside a server shared containeer. the hash file inside the shared containeer has no links so I couldnot validate the link names. I read your post It says I need to have server transformer also inside containeer. But in documentation they mentioned I can use server ...

Hi, Can any one Help me in getting me out from this error. Hi, I have source file text file with material char(7) as a columm and Iam having a OSP in DB2 table with Varchar(7) as a key. Iam looking with Material to OSP . I used functions to trim whitespaces after material and I also had two Leading ...

Hi, Iam facing a fatal error when Iam trimming white spaces. I have source file text file with material char(7) as a columm and Iam having a OSP in DB2 table with Varchar(7) as a key. Iam looking with Material to OSP . I used functions to trim whitespaces after material and I also had two Leading 00...

Hi, Can any one help me .I have a requirement like this, I want to Lookup a DB2 table . I have to join the keys from_src (flat file ) and Lookup table. And I want to write the output to three stages 1. To the seq file with constraint : Is Null (Lkup_Tab.BB) 2. To the seq file with constraint : Not I...

Hi Amey Vaidya, Actually I tried uor optioin Transformer1.............................................RmVdup1 output columm from Transform1.....Reckey,OutRecI Transformer2................................................RmVdup2 output columm from transform2......Reckey,OutRecD RmVdup1....(RCPOFF).......

Hi Kumar,

The names of the links from two transformers are not identical.It shows an error like this


main_program: Fatal Error: Interface component "OutRec" is not a value field.




Thanks,
Somaraju

Hi Kumar, Please correct me if Iam wrong. Actually my requirement is to write two datasets in to a single dataset using funnel stage. I have first daaset with Reckey and OutRecI columms and second dataset with Reckey and OutRecD columms with same metadata. I have 1 .transformer.......... Rmvdup........

Hi, Please help me and correct me if Iam wrong. I have columm like Reckey and OutRec comming from two transformers output and Iam writting to two datasets. Iam mentioning Reckey as key sqltype char and length '1' and nullable not. where for OutRec Iam not giving as key and sqltype varchar and length...