Copy Paste Definition Columns

jacal · Post by **jacal** » Mon Nov 17, 2003 9:39 am

Hello,

I have a Table Definition in a job that needs to propagate for many stages all the flow of the job. However, someone told me that in DataStage Designer, I could do a simple operation "copy and paste" of the Input Definition to another Link (without opening the Stages).
Does anyone know how to do this? Is there any Keyboard Shortcut to do this? I tried the CTRL+C and CTRL+V and nothing has happened.

Thanks the help,
Rui Moito

chulett · Post by **chulett** » Mon Nov 17, 2003 9:45 am

They were probably referring to the new "Propogate Columns" option. Right-click on a Transform, select Propogate Columns and then select the input and output link you want to "copy" all columns from/to.

Peytot · Post by **Peytot** » Mon Nov 17, 2003 9:47 am

You can 'save' your Table Definition (in your first stage) and after in your other stages choose the option 'load'.

Pey

jacal · Post by **jacal** » Mon Nov 17, 2003 11:09 am

Thanks for the help,

it seems that the "copy and paste" operation will be possible if I upgrade to version 7. In version 6, I only can save the definition to the metadata and then drag this saved definition to the links, without opening the stages.

Thanks for the tips,
Rui Moito

chulett · Post by **chulett** » Mon Nov 17, 2003 11:15 am

Not quite... check out the propogate option. It does exactly what you asked about without the hassle of opening the stages and the whole save/load/drag thing.

roy · Post by **roy** » Tue Nov 18, 2003 6:11 am

Hi,
FYI you can also drag & drop the table definition from the repository in the designer directly on the link in the designer which will propegate the link, but you'll still need to enter and edit transformer derivations

IHTH

Teej · Post by **Teej** » Tue Nov 18, 2003 6:51 am

chulett wrote:Not quite... check out the propogate option. It does exactly what you asked about without the hassle of opening the stages and the whole save/load/drag thing.

Yes.

But it doesn't provide you with a visual reference down the line, such as "... okay, here I need to handle this key field... hey... did it propagate to here?"

Propagation is a good idea that sorely need a better implementation. We need visual references to known propagations. This is also why I do not use the Table format in pulling data from Oracle -- no visual references.

I know Ascential Consultants are beating the Propagation drums, but their only real benefit is the "hey, it's easier", and does not address my innate need to see the columns.

-T.J.