Interested to Buy Any Domain ? << Click Here >> for more details...
How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
- 1 Answers
- 3507 Views
- IBM, I also Faced
- E-Mail Answers
Answer / isha
We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention some types of transformation?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
how many types transformations supported by sortedinput?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
what is the function of 'F10' informatica ?
Using Connected or unconnected lookup for performance wise which one is preferable?.
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What is aggregate cache in aggregator transformation?
Can we get 1st record through Informatica(without sequence number).
Teradata 
