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 to load the data from a flat file into the target where the source flat file name changes daily?
What is the command used to run a batch?
Write the unconnected lookup syntax?
Can we create a Integration service without a Repository service and vice versa?
What's the layout of parameter file (what does a parameter file contain?)?
To import the flat file definition into the designer where should the flat file be placed?
How many types of sessions are there in informatica.please explain them?
what is song in infrmatica...?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Why sorter is an active transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Describe data concatenation?
What are the performance considerations when working with aggregator transformation?
How would you copy the content of one repository to another repository?
What are mapplets? How is it different from a Reusable Transformation?