DSXchange

Dear All, Good Day, We are building a datawarehouse from scratch which we don't have at the moment. We have daily transactions of apprx 100 million records to transform and load into our new DW enviroinment. We need to do few transformations like trimming on each field and aggregate functions before...

Hi Chulett, Let not confuse with the sample data above. To make it simple it is shown as below INPUT --> ID_NUMBER 1234 1234 1234 1111 2345 2345 Output required ---> ID_NUMBER | ENTITY_ID 1234 | 001 1234 | 002 1234 | 003 1111 |001 2345 |001 2345 | 002 Any idea. Regards Cherry

Dear All, I have the following requirement. I have a member who can have multiple benefits as shown below: MEMEBR_ID NAME BENEFIT NMBR001 AAA 1 NMBR001 AAA 2 NMBR002 BBB 1 NMBR002 BBB 2 NMBR002 BBB 3 In the above example NMBR001 has got 2 benefits and NMBR002 has got 3 benefits. I wanted the output ...

Hi Ray,

The name field is not fixed with number of delimiter's say for one record it might have 5 delimiters and other row would have more than 5. In this case iam not sure if column import stage will work.

Thanks
Cherry

Hi All, I have the below scenario and my pinput data is as below Input ----- Id, Name 1, r;b;c 2 a;d;g;h;j Name field has data which is ';' delimited but it is one record I would like my input to be as shown below: Output ------ Id, Name 1,r 1,b 1,c 2,a 2,d 2,g 2,h 2,j Any help here please. Thanks C...

Dear All, I have a scenario as below: Input data: IDNumber Code 12345 1001 12345 1006 12345 2001 67891 1003 67891 1004 67891 1006 67891 2001 67891 2004 67891 2008 13579 1001 13579 1002 13579 1007 13579 2001 This is what I want as output data: IDNumber Code1 Code2 Code3 Code4 Code5 Code6 12345 1001 1...

Thanks Michael,

I checked and found the data from imput is not matching to the output dataypes and the data being truncated.

Regards
Cherry

Hi All, Iam trying to load data from a dataset to DB2 using Bulk load stage. Iam getting the following error: SQL3502N The utility has encountered "200" warnings which exceeds the total number of warnings allowed. Will someone please help, what would be the fix. Thanks in advance Regards C...

Thanks anbu for th esolution. Let me try and get back to you.

Hi All, Good Day.., I have the following requirement. From the source I would get only the START DATE and I need to populate END DATE in the Output file. Greatly apprciated if anyone has solution. INPUT DATA ---------- ID NBR SEQNO START DATE 7856 01 20100905 10:12:45 7856 01 20100905 10:16:14 7856 ...

Hi All, I have the following requirement. My Input data looks like: SAP_CODE AIM_PART CRD_PART ACM_PART 1 M 1 2 2 F 2 1 3 U 3 3 My Output should look like: SAP_CODE CODE PART 1 M AIM_PART 2 F AIM_PART 3 U AIM_PART 1 1 CRD_PART 2 2 CRD_PART 3 3 CRD_PART 1 2 ACM_PART 2 1 ACM_PART 3 3 ACM_PART Any help...

Hi All,

Iam getting the following warning message:

DSD_GenerateEvents.B:LinkReport for Job009_CC_AggrYTD.EDW01_PAYMENT.LN_CompassConv_IN not found.

Could some please help me what this message is and how to get rid of it.

Thanks in advance

Regards
Cherry

Try this DSLink149.INTFC_FILE_CATG[1,4]

Regards
Cherry

Hi All,

In My previous message I have mentioned, the job type as Parallel.

The job type is server.

Many Thanks


Regards
Cherry

Hi All,

We recently upgraded from 8.0.1.2v to 8.1.00v.

In 8.0.1.2v iam doing lookup directly on the table. But the same job design is not working in 8.1.00v.

In 8.1.00v, I need to add a hash file for the lookup to work.

Do any one has an idea why is this change.

Regards
Cherry.