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
- 13320 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / g. manthiramoorthy
Using dynamic lookup, you can load both simultaneously.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / amedela chandra sekhar
use surrogate pipeline technique first data loaded into dimension table ,then loaded into fact fable with primary and foreign key technique b/w dimension and fact table.
use lookup t/r.........
| Is This Answer Correct ? | 2 Yes | 0 No |
Differentiate between source qualifier and filter transformation?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
what is the function of 'F10' informatica ?
Can you copy the session to a different folder or repository?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to extract original records at one target & Duplicate records at one target?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What are the circumstances that infromatica server results an unreciverable session?
how to declare array in plsql?
Explain load alternative records / rows into multiple targets - informatica
 Informatica Checkpoints
Teradata 
