Interested to Buy Any Domain ? << Click Here >> for more details...
how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
- 2 Answers
- 7201 Views
- TCS, I also Faced
- E-Mail Answers
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 |
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
Can we create two repositories on same database instance in oracle?
Informatica and datawarehousing courses in Pune?
On which transformations you created partitions in your project?
Why we use lookup transformations?
What are the different ways to implement parallel processing in informatica?
Can we create out put ports in source qualifier t/r?
How do you load unique records into one target table and duplicate records into a different target table?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
How to load last n records of file into target table - informatica
What is mapplet in informatica?
Teradata 
