Interested to Buy Any Domain ? << Click Here >> for more details...
how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
- 2 Answers
- 6335 Views
- Sonata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sree
dimension tables are loaded first and fact tables.As all primary keys of the dimension table is linked with the foreign keys of fact table for proper lookup we need to load dimension tables first.
| Is This Answer Correct ? | 7 Yes | 0 No |
The order of loading the schema is as below:
1)Dimension Table
2)fact table
| Is This Answer Correct ? | 5 Yes | 0 No |
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What all join we can perform in LOOKUP transformation?
explain about unit testing? in real time?
What is aggregate cache in aggregator transforamtion?
Without using any transformations how u can load the data into target?
.prm wirh repalce .txt is possible?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
how to run 2 workflows sequentially. plz respond what is the process?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani
diffrence between command task and control task
Teradata 
