How to load dimension and fact in same mapping at same time.explain me the log

How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.

Question Posted / prgn

How to load dimension and fact in same mapping at same time.explain me the logic used for that sce..

Answer / isha

We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.

Is This Answer Correct ?

0 Yes

0 No

More Informatica Interview Questions

How to eliminate 1st and last rows from the source and load the inbetween rows.

Repository user profiles

What is Collect performance data in informatica and what is the use of it.

select count(1) from emp? what is the o/p?

what is the difference between stop and abort

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

Which transformation is needed while using the Cobol sources as source definitions?

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

Is stop and abort are same in informatica?

Is it possible to use a client with different version than that of its Informatica server?

How to compare Source and Target table, without using dynamic lookup?

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

For more Informatica Interview Questions Click Here