What is dimensional table? Explain the different dimensions.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,


What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,


can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,


A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  


What is a repository manager?

0 Answers  


comonly how meny mappings r there in Banking projects?

1 Answers  


I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,


if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,


i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,


What are data-driven sessions?

0 Answers  


How can a transformation be made reusable?

0 Answers   Informatica,


Categories