Answer Posted / shivaleela
Dimensional Table:-It contains detailed information of one
Particular department
Eg:-Customer dimension it contains all the information
about the customer like name,place,DOB, city n so on along
with one primary key.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse.
what are 3 tech challenges/ common issues you face?
Differentiate between joiner and lookup transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the performance considerations when working with aggregator transformation?
whats the logic to load the lower level of granularity of data to fact table.
Explain in detail about scd type 1 through mapping.
What will be the approach?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How many ways are there to create ports?
How to extract sap data using informatica?
Separate from a database, an information bazaar, and an information stockroom?
Define filter transformation?
Describe an informatica powercenter?