How you know when to use a static cache and dynamic cache in lookup transformation?
No Answer is Posted For this Question
Be the First to Post Answer
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
what is the difference between static and dynamic
what is mapping optimization? wat are the techniques for tat
which quality process u can approach in ur project
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the aggregator transformation?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is persistent lookup cache?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
what is pre and post sql and what is diff between source presql and target pre sql
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Which one is better performance wise connected/un-connected lkp?why?