how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
- 2 Answers
- 5611 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 |
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
what is incremental data aggregation?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
Different circumstance which drives informatica server to expel records?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
What are partitions in informatica and which one is used for better performance?
Describe an informatica powercenter?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
Can we use the mapping parameters or variables created in one mapping into another mapping?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What is a design?
Teradata 
