What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
No Answer is Posted For this Question
Be the First to Post Answer
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
Repository user profiles
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How can you define user defied event?
What is the fact table?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
what is the architecture of any Data warehousing project?
What is Data Caches size?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?