what is the logic will you implement to load data into a
fact table from n dimension tables?
Answer Posted / satyaranjan
Always load data from dimension to fact is incremental load
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
What is a filter transformation?
Define Pmrep command?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to use pmcmd utility command?
What are the types of lookup transformation?
What are the transformations that are not supported in mapplet?
Why filter transformation is an active one?
Describe expression transformation?
Clarify the aggregator change?
what is the complex transformation you used in informatica
Name the different lookup cache(s)?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is meant by target load plan?
How to call shell scripts from informatica?