how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
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 |
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
Briefly explain the aggregator transformation?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
What is diff joiner and lookup
difference between shortcut and reusable transformation?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
What is synonym?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
what are the transformations that restricts the partitioning of sessions?
From where we can start or use pmcmd?
How can you increase the performance in joiner transformation?