Question { HCL, 2688 }

what is degenerated dimension table with scenario

Answer

It is a dimension field in the fact table that doesn't have a corresponding dimension table. As a result - a degenerate dimension will use the field as key, name and its only attribute.
Degenerated dimension can be used to link back to the source as it is a natural key of the "parents" of the line items. It is used in reporting. Degenerate dimensions commonly occur when the fact table's grain is a single transaction. Although there is no corresponding dimension table of attributes, degenerate dimensions can be quite useful for grouping together related fact tables rows.
e.g.In health care, degenerate dimensions can group the claims items related to a single hospital stay or an episode of care

Question { IBM, 1586 }

What are the different ways to deploy the code in informatica?

Answer

There are different ways to deploy code in Informatica.
1) If code needs to be deployed from DEV to TEST then Export XML of DEV workflow in the local directory and then connect to Test repository and import that XML in a TEST.
2)Create a deployment group of all objects that need to be deployed from one environment to another and then deploy that group to other environment

Question { Accenture, 2647 }

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Answer

Joiner Transformation is better in case of heterogeneous join(join 2 tables exist in the different database).
While lookup and SQ is better approach to join two tables which exist in same database