DSXchange

Hi In one of the Datastage projects there are more than 400 jobs in PROD. Some versions of the jobs had been released (export-import) as job designs from DS Manager. Later some jobs were released as job executables from DS Manager. Now, if someone opens a job in PROD they might see the job design bu...

I think that the Aggregator may not work in this case because of the data type. DS Gurus,correct me if I am wrong. You can try this approach: Pass the input file to a transformer and get the output as 1|A 1|B 1|C 1|D by applying some logic in the transformer. Then pass it to a Pivot stage to get it ...

1. What are you setting the Aggregation Type as ?

2. Which column are you setting as the "Column for Calculation?

3. What are the data types for : User_ID|Level1|Level2|Level3|Level4 ?

First time when you split your file, capture all such records that do not have HOME PHONE OR WORK PHONE in a separate file.

In the end you can append this file to the actual output file.

1. Split your input file into 2 streams based on the LOC (home or work). This will split into 3 rows each. Have all the columns except LOC.

2. Do a Full outer join on the 2 streams thus generated. Keys should be ID and COUNTRY.

You can check it in DS Help.
Find for CASE

I believe you cannot write CASE statements in the derivations but they can be written within a function.

Correct way to write is:
if columnname='a' or columname='b'

Please elaborate on what information you seek regarding Case statement.

pls ignore that repy....that's from Director...not Admin

Go to Job--> Cleanup Resources.
You would see the PID and the corresponding processes.
Select the required PID and use the Logout button.

Hi Not sure if you found a solution to your problem, but here's something that might be useful : (This is from DS Director manual) If, during sequence execution, the flow diverts to an error handling stage, DataStage does not checkpoint anything more. This is to ensure that stages in the error handl...

Try one more approach:
Don't run the parent sequence...just run the child sequence.
Observe if you get the same result.
This would help you to identify where the exact problem is.

Yeah, this would be helpful when we have many columns and want to see only 4-5 columns.
Another option that could be provided is to find a column by its name or its data type ...for example display all data that is of type Decimal 18,2

It is always better to sort the data before giving it to the Remove Duplicates Stage.

I assume that jb_16 and jb_25 are the Job Activity stages.

In these 2 stages and the child sequence, what option have you set for Execution Action?