How can we integrate different flat file data in a single
mapping and with in a single execution
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
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.
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
what is the flat file partition and where have to specify it
What is domain and gateway node?
how we can do session partition in informatica any one explain me clearly? thanks advance.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Why we require dwh in particular projects?
How do you create single lookup transformation using multiple tables?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,