Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?


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

Post New Answer

More Informatica Interview Questions

Mention few advantages of router transformation over filter transformation.

0 Answers  


Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  


When the informatica server marks that a batch is failed?

1 Answers  


what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,


How many transformations can be used in mapplets.

0 Answers  






How do you use reject loader.

0 Answers  


If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  


how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,


without update strategy how to insert &update?

1 Answers   DELL,


What is native users?

0 Answers  


in which situations do u go for snowflake schema ?

2 Answers   TCS,


I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


Categories