how will u load the data to diminision tables and fact tables,what is the hira

how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy

Question Posted / venkat

Answers were Sorted based on User's Feedback

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are us..

You load dimension table before loading fact table. But
using Dynamic Lookup, you can load both simultaneously.
======

Is This Answer Correct ?

8 Yes

0 No

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are us..

Answer / abc

I think use the constraint load order and target load order
plan

Is This Answer Correct ?

0 Yes

1 No

More Informatica Interview Questions

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

How do you load alternate records into different tables through mapping flow?

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

What could be the possible resons of locks by user?

Hi experts, can anyone tell how much we use plsql in real time

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

Can we create a Integration service without a Repository service and vice versa?

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

which is better perfomancewise lookup or joiner and why?can anyone give example?

why do we go for update strategy tr in SCD rather using the session properties?

What is the meaning of decode in informatica?

Define Pmrep command?

For more Informatica Interview Questions Click Here