Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 86664 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / giri
Schema is structure of information
1.STAR SCHEMA
-------------
Centralized Fact table connect the one or more denormalized data
2.SNOW FLAKE SCHEMA
-------------------
Centralized Fact table connect the one or more normalized data
3.STAR FLAKE SCHEMA
-------------------
One or more centralized fact table connect the single denormolized data
| Is This Answer Correct ? | 28 Yes | 23 No |
Post New Answer View All Answers
which one is better performance wise joiner or look up
Explain lookup transformation is active in informatica
To import the flat file definition into the designer where should the flat file be placed?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain constraint based loading in informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain target update override in informatica
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
Explain the etl program with few examples.
What is informatica etl tool?
What is an unconnected transformation?
What is the format of informatica objects in a repository?
What is complex mapping?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
