Hi
I have dataflow like:
DSOs DSO_1 and DSO_2 are connected to DSO_3 via transformations.While creating transformation between DSO_2 and DSO_3,We are thinking of having a look up onto DSO_1 to get some charateristics from DSO_1 into DSO_3(all these characteristics are already updated into DSO_3 from DSO_1 via transformations).My doubt is,how do we decide or on what basis,we decide which characteristics we need to bring into DSO_3 in this look up.
When charcateristics are coming into DSO_3 via transformation from DSO_1 then what is the need to bring them into DSO_3 via transformation from DSO_2 using LOOKUP on DSO_1 again?
Thanks.