Page 1 of 1
Copy Paste Definition Columns
Posted: Mon Nov 17, 2003 9:39 am
by jacal
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
Posted: Mon Nov 17, 2003 9:45 am
by chulett
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.
Posted: Mon Nov 17, 2003 9:47 am
by Peytot
You can 'save' your Table Definition (in your first stage) and after in your other stages choose the option 'load'.
Pey
Posted: Mon Nov 17, 2003 11:09 am
by jacal
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
Posted: Mon Nov 17, 2003 11:15 am
by chulett
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.
Posted: Tue Nov 18, 2003 6:11 am
by roy
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
Posted: Tue Nov 18, 2003 6:51 am
by Teej
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.