What is factless fact schema?
Answer / mln
The fact which does not contain any facts or mesaurables.
Ex:the fact table which is used to store the students
information is he came to school or not cannot have weather
they are attending all classes.
which is a measure
Is This Answer Correct ? | 5 Yes | 4 No |
How the facts will be loaded? explain
how to remove staging area
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
what is shortcut in informatica? difference between shortcut,reusable object?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a data modeling?
How to delete duplicate record in Informatica?
What is target load order?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
what is mapping performence?
Can you copy the batches?