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
- 12978 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 |
Explain the different dimensions.
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
What is informatica? Why do we need it?
what is procedure to use mapping variable in source qualifier transformation? with example
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Mention a few design and development best practices for informatica?
What do you understand by a term domain?
What is the meaning of decode in informatica?
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
what is the difference between onsite & client site?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
What aer the out put files that the informatica server creates during the session running?
Teradata 
