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
What is a shortcut and copy in Informatica and how two are different with each other?
What is session task and command task?
What is the sql query overwrite in source qualifier in informatica
How to load last n records of file into target table - informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the types of data warehouses?
How do you change a non-reusable transformation to reusable transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the guidelines to be followed while using union transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
what is the -ve test case in your project.
Differentiate between router and filter transformation?
What are batches?
Define mapplet?
Which version configuration tool used in ur project?