how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
Answers were Sorted based on User's Feedback
Answer / gm
You load dimension table before loading fact table. But
using Dynamic Lookup, you can load both simultaneously.
======
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / abc
I think use the constraint load order and target load order
plan
| Is This Answer Correct ? | 0 Yes | 1 No |
How many numbers of sessions can one group in batches?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is an expression transformation?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
How many types of sessions are there in informatica.please explain them?
how to get max value record into one target and remaining records into another target?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
How to generate the HTML output using Informatica.
Why the workflow is failed after running two hours in informatica?