Hi,
I am new to datastage, earlier worked on some other ETL tools, I have develoed a job in which I am populating to a target file with 1000 columns. I have few set of rules which will populate say 200 columns of this file with after applying some business rules and rest 800 columns I will set to NULL. Question here is target file metadata keeps on changing from time to time since projects is in early stages, problem I am facing is whenever target metadata gets changed, I will load it in output of transformer, it will erase all rules I have written in transfomer. Is there any effective solution to this? Thanks
save Derivations
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
I'm curious what kind of changes you are seeing in your target metadata and what exactly you mean by "load it in output of transformer"? If the changes are not substantial, make them manually. If you are only adding new columns then don't allow it to overwrite the existing ones.
Still, a better explanation of what you are doing would help get you better answers. Also realize that in most databases that I am aware of, you can simply not mention a column in the output link to have it set to null as that is the typical default value, so leaving them out of the job unless they actually need a derivation would probably help as well.
Still, a better explanation of what you are doing would help get you better answers. Also realize that in most databases that I am aware of, you can simply not mention a column in the output link to have it set to null as that is the typical default value, so leaving them out of the job unless they actually need a derivation would probably help as well.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am