Interested to Buy Any Domain ? << Click Here >> for more details...
i want to load data in to two targets..one is dimension
table and the other is fact table?how can i load ata a time
- 3 Answers
- 12976 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / john
Generally we all knew that is,In Datawarehouse
environment,we should load data first in the dimension
table then we load into the fact table..bcoz fact table
which contains the Primary keys of the dimension table
along with the measures.
So we need to check first that whether the fact table which
you are going to load that has foreign key relationship
with the dimension table or not?If yes,Use pipeline mapping,
and load dimension data first in first pipeline and in the
second pipeline load fact table data by taking the lookup
transformation on the dimension table which has loaded data
already..and return the key value from the lookup
transformation then calculate the measures by using
Aggregator and also give "group by" on the dimension keys
and map to the Target(Fact) prots as required.
most importantly specify the "Target Load Plan"
where dimesion target as first,fact table target as second.
let me pls correct my answer If i am wrong..
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
Which transformation should we use to normalise the COBOL and relational sources?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the different types of transformation available in informatica.
How to do unit testing in informatica? How to load data in informatica ?
Explain the aggregator transformation?
what is the -ve test case in your project.
What are different types of transformations available in informatica?
Define joiner transformation?
How to load the data from people soft hrm to people soft erm using informatica?
What are the different components of powercenter?
What is an Integration service in Informatica?
Implementation methodology
Explain the difference between mapping parameter and mapping variable?
Name the different lookup cache(s)?
