When we are using Dynamic Cache,which options we will select
in session level?
Answer / ankit
You need to select "Dynamic lookup cache" property in session and also select either "Inser else update" or "update else insert".
Thanks,
Ankit
| Is This Answer Correct ? | 1 Yes | 0 No |
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
explain different levels in pushdown optimization with example?
Which are the different editions of informatica powercenter that are available?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
what is difference between COM & DCOM?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
If there are more than one sessions running parallel in a worklet, which will be the last session ?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
write a query for how to eliminate the duplicate rows without using distinct?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
what is casual dimension?