how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
- 2 Answers
- 5365 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / abc
I think use the constraint load order and target load order
plan
| Is This Answer Correct ? | 0 Yes | 1 No |
Is it possible to use a client with different version than that of its Informatica server?
How will you display "Mr" for male & "Mrs" for female in target table?
how many session run unix environment what command using ?
Explain the difference between mapping parameter and mapping variable?
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.
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is staging area?
What is the Difference between DSS & OLTP?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Teradata 
