how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
- 2 Answers
- 7442 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 |
Explain how many types of dimensions are available in informatica?
What is a candidate key?
What are the measure objects?
Mention a few design and development best practices for informatica?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
What is dimensional table?
How to join three sources using joiner?
How to partition the Session?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
design of staging area?
Define filter transformation?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Teradata 
