What are the different types of schemas?
Answer Posted / gopi
star schema
snow flae schema
hybrid schema
multistar schema
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Define Pmrep command?
Enlist few areas or real-time situations where informatica is required.
How do we call shell scripts from informatica?
What are the new features of informatica 9.x in developer level?
What is the need of an ETL tool?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain sql transformation in script mode examples in informatica
Mention few advantages of router transformation over filter transformation.
How to open an older version of an object in the workspace?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is dynamic cache?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How are indexes created after completing the load process?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?