What is dimensional table?


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

Post New Answer

More Informatica Interview Questions

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


How to create the source and target database connections in server manager?

0 Answers   Informatica,


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  


why we use stored procedure transformation?

4 Answers   IBM,


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?

3 Answers   HP,






what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,


I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,


in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,


Explain about cumulative Sum or moving sum?

0 Answers   Informatica,


What are the uses of a Parameter file?

3 Answers   CSC,


IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,


Categories