Answer Posted / rr
Star schema has denormalised dimension tables connected to
a single fact table.
Snow flake schema has normalised dimension tables.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the main issues while working with flat files as source and as targets ?
Explain what are the different versions of informatica?
Explain scd type 3 through mapping.
How to generate sequence numbers?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain what are the different types of transformation available in informatica.
What are the features of complex mapping?
How many types of sessions are there in informatica.please explain them?
How is union transformation utilized?
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
What is informatica etl tool?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the measure objects?