DSXchange

Hi
I have requirement where data comes from 3 source system with source system code,

Code and description . You have to load one record with unique code with correct description

How to achieve this in datastage. Also can we
Use quality stage to get correct description
Thks

Hi We have below sample data Source Code desc A. ABC Invalid n/a B ABC Inv n/a C. ABC. INV n/a Output Source. Code. Desc AorBorC. ABC. Invalid n/a I want above output record . How to implement in datastage to get one record also how can I use Quality stage to get valid correct description Thks

HI

I have to store the source code table name in the target and table definition are different for each source tables. how can I implement the above logic in data stage.

If table definition were same I can loop and pass table name as parameter and store in target.

Please share your idea.

thks

Hi

i have to implement SCD type 2 for 20 dimensions .

Is it possible to create shared container of scd type 2 logic inbuilt

and how to pass the type 2 columns dynamically .

let me know if it is possible

thks

Hi
I recompiled all the jobs. Still I am having this issue. Is there any fix for this

issue.client don't want to downgrade os to 5 . I don't know where to start.

Please share your ideas

This

HI

the permission on the whole project directory are
drwxrwxr-x .Is this sufficient or we have to give 777


We installed service and engine tier service pack 2 8.7 .

is there any for Client Tier..

thks

Hi We run the FIX pack 2 for 8.7 but we still have following errors 1) when we run the jobs jobs status stay in ready mode with out doing any thing. 2) we are getting following error in Engine Tier.CDIIN2899E: Failed to catalog: /InformationServer/Projects/xxx/Project/xxxx/DSD_BP.O/DSCheckSum.B in c...

hi We just upgrade the OS from redhat 5 to redhat 6 and running datastage 8.7 on Z system. After the upgrade we are not able to import the jobs . we are getting following errors ERROR on CREATE.FILE command( An error has occurred during datastage initialization .please contact system admin error cod...

HI

Thanks for reply .Your solution worked

Hi Thanks for your reply.My mistake I did not explain correclty on my previous email .I updated my requirement .I will have different keys. Some how i have to add a logic to only append the rows when there is same key . Input Key 1 a 1 b 1 c 1 to N 2 a 2 b 2 c 2 to N Output 1 a:b:c 2 a:b:c thks

Hi I want to convert data from rows to columns for same key value .It can have N number of values . Input Key 1 a 1 b 1 c 1 to N Output 1 a:b:c I cannot use vertical pivot because I dont know array size. I also tried to transformation loop with loopvar <= MAX(COUNT) .But it is looping same value Can...

HI I did not understand what do you mean by this ''Have you registered interest in the table metadata '. But I validated all the connections within the project .I am also sending the IA JOb status. IA Job Status ----------------------------------------------------------------------------------------...

HI

Are you talking about check box include columns with lenght over 512 characters in Analysis setting tab.

But this one is for over 512 characters but I am getting error for over 255 characters in length

Hi

When I tried to run column analysis on other machine it fails for columns greater than 255 characters in length.Is there any way in Information analyzer
to say do only column analysis for first 254 characters only.


thks

HI I validated IADB and DB2 connections and I imported Metadata sucessfully . but when i try to run column analysis i am getting following error In Analysis Engine tab I validated the settings In Analysis Database I validated engine and client connections Data connection (DB2 connector) that connect...