save Derivation
Posted: Wed Aug 19, 2009 10:30 pm
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
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