Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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..

Answer / gm

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

Post New Answer

More Informatica Interview Questions

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

0 Answers  


How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  


how many session run unix environment what command using ?

1 Answers   HCL,


Explain the difference between mapping parameter and mapping variable?

0 Answers  


A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,






How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,


followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,


if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  


What is staging area?

11 Answers  


What is the Difference between DSS & OLTP?

5 Answers  


By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,






Categories