DSXchange

How about some business-like specifications for the derived fields? For example it seems to me that: Top_Flag = "has no parents" Bottom_Flag = "has no children" Child_Level = level in hi ... Thanks Ray. For top_flag and bottom_flag the logic is for the 1st row : A is the parent ...

My whole point is that there are no code tags in your post. Look again at your "picture" and tell me how much that depicts as it stands now. You needed to spell everything out in words at which point the picture is pretty well moot. Something like this could stand on its own, however: A -...

[sigh] Picture? What picture? Did you not read anything I posted? :? chulett, I tried my best to arrange it. I may be incorrect, but i wanted to put my understanding of the problem in the forum to get some help. Can you please let me know which part of my post is not clear and the way you like me p...

:!: You still hadn't put anything properly so I edited your post and added the tags for you. Note that I made absolutely no attempt to ensure anything lined up, you can go back and do that. :idea: Peoples, the 'preview' function [b]is there for a reason.[/b] Make use of it. The forum software remov...

Start by enclosing your examples in Code tags, so we can understand what's happening. ... I am sorry for not putting it properly. Here we go: A | | B C | D Result should be : Parent Child Top_F Bottom_F Child_Level Parent_Level 'A' 'B' 'Y' 'Y' '2' '1' 'A' 'C' 'Y' 'N' '2' '1' 'C' 'D' 'N' 'Y' '3' '2'...

Hi All, I have below requirement to be implemented. A | | B C | D Result should be : Parent Child Top_flag Bottom_flag ChildLevel ParentLevel A B Y Y 2 1 A C Y N 2 1 C D N Y 3 2 A D Y Y 3 1 A A Y N 1 1 B B N Y 2 2 C C N N 2 2 D D N Y 3 3 I have written a recursive sql query which is giving me the re...

Hi All, In one part of my job design I have a snippet of data in the below format: Table1: Col1 Col2 Col3 100 2000 1 101 2001 1 102 2002 1 103 2002 1 Table2: Col1 Col2 1 DK 2000 9200 2001 9300 2002 9400 Target Should be: Col1 Col2 Col3 100 9200 Dk 101 9300 Dk 102 9400 Dk 103 9400 Dk I was trying to...

Hi All, In one part of my job design I have a snippet of data in the below format: Table1: Col1 Col2 Col3 100 2000 1 101 2001 1 102 2002 1 103 2002 1 Table2: Col1 Col2 1 DK 2000 9200 2001 9300 2002 9400 Target Should be: Col1 Col2 Col3 100 9200 Dk 101 9300 Dk 102 9400 Dk 103 9400 Dk I was trying to ...

chulett wrote:You're right, I didn't look close enough at the data and the desired output when I made my statememt. D'oh.

Yes It worked with Aggregator. Thanks for the valuable inputs.
Sorry for the delay.

You're using the right stage, just not properly it seems. Be specific - how exactly do you have it setup? ... Job Design is as below: Sequential File ---- Transformer --- Pivot Stage ---- Sequential File In Pivot Stage: Pivot Action = Vertical Pivot Properties: Col1,Col2,Col3,Col4. Am I missing som...

What about using aggregator with max(column) ? ... Thanks for the quick reply. The data can also be like the below one: col1 col2 col3 col4 101 0 1111 0 101 0 0 1112 101 1113 0 0 Here Col1 is the source column which I pulled it to the end, which I would like to drop at later point of time. In the a...

Hi All, I have data in the below format: col1 col2 col3 col4 101 1234 0 0 101 0 1111 0 101 0 0 1112 The desired output should be Col1 COl2 Col3 Col4 101 1234 1111 1112 I have used Vertical Pivot but not able to get the required result. I have mentioned the below properties in the Pivot. Pivot Action...

The Project name is same on old and new machines. I tried force compile as well..but it didn't work. The config file we are using is: main_program: APT configuration file: /apps/Ascential/DataStage/Configurations/XYZDefault.apt /* DataStage Configuration File - Project=XYZ File automatically generat...

Currently we are using Datastage version 7.5.3 and OS AIX 5.3 version.
Do you think we need to request IBM to install any patches to resolve this issue.
Is there a workaround? Any Ideas?

I created a simple job(Oracle-Basic T/F-Seq File) with a basic transformer in it. Even this is aborting with the same error. BASIC_Transformer_10,1: Unable to open project 'EDW' - 81016. But when i call a Server Routine in the Basic Transformer, job aborted again with the same error. BASIC_Transform...