what is bridge tables in informatica
Answer / gangam rajesh
Bridge table is a association table between two multivalued
dimension tables i.e. which have many to many relation.
Actually database doesn't support m to m relationship so
by using this bridge table we convert the m to m relation
ship into two 1 to many relationships.Bridge table contains
primarykeys of both dimensional tables as a compositekey
| Is This Answer Correct ? | 7 Yes | 0 No |
What is data transformation manager process?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
what is dynamic cashe
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
What is the commit type if you have a transaction control transformation in the mapping?
How the dimensions will be loaded?
In session log thier should not be a single error how will u do
what is galaxy repository?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).