Answer Posted / tamilarasan m
Star fact table join with all the dimension tables.All the
dimension tables are denormalized.ain Snowflake dim table
join with another dimension.All the dimension r normalized
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In informatics server which files are created during the session rums?
What is mapping debugger?
How do you load unique records into one target table and duplicate records into a different target table?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
I have a flat file, want to reverse the contents of the flat file
Explain sql transformation in script mode examples in informatica
list out all the transformations which use cache?
What is parallel processing in informatica?
Enlist the various types of transformations.
What is meant by pre and post session shell command?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is a dimensional model?
How to create or import flat file definition in to the warehouse designer?