How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
Answer / isha
We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
what is the diff b/w cached and unchaed look ups
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How will you combine 3 different sources with a single source?
How to update source definition?
Which transformation should u need while using the cobol sources as source defintions?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
what is pre and post sql and what is diff between source presql and target pre sql
which one is better performance wise joiner or look up
Which version configuration tool used in ur project?