Level Number in the output columns
Moderators: chulett, rschirm, roy
Level Number in the output columns
I am trying understand a job where, in the transformer stage, on one of the output column tabs, I see the column called Level Number. How do I display this column on the 2nd tab?
I tried to put in a value in the Level number box in the Edit Column Metadata window. That doesn't do it.
I tried to put in a value in the Level number box in the Edit Column Metadata window. That doesn't do it.
Re: Level Number in the output columns
If you are already able to see the column defined, it should be out there, probably you have to scroll or something.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
kumar_s, just right clicking will not show the column. I had already tried that. What's interesting is, on one tab, it shows Level Number and on the other it doesn't. On the tab on which it shows Level Number, I went to Edit Column Meta Data window and I cleared the Level Number box on bottom/left for all columns. This makes the Level Number column disappear. However, if I insert the value again in the Level Number box, the column does not reappear. This is really baffling!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have to click Apply to get anything saved.
I would recommend editing the table definition in the Repository to add the Occurs value, and then to load the table definition into your job from there.
You might also try editing the column definition on the other end (the passive stage end) of its link.
I would recommend editing the table definition in the Repository to add the Occurs value, and then to load the table definition into your job from there.
You might also try editing the column definition on the other end (the passive stage end) of its link.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.