if we are extracting 600000 records from a source table so
how much volume of records frequently we load in warehouse.
(Iknow its depend on client requirement) still i want to
know how much volume of records store in warehouse.
Answers were Sorted based on User's Feedback
Answer / guest
u told its based on clients requirment only.then wat boss?
thats the answer.if he needs only one record we wil load
only one record. if he need 599999 record to be in target
we wil do that. its based on how we create dimension and
fact in data warehoue. ultimately al our data has to help
the client to see the needed data and to analyse and to
take strategic decisions from it.
| Is This Answer Correct ? | 1 Yes | 0 No |
how many types of dimensions are available in informatica?
without table how to come first record only in oracle?
Can I create one wrkflw which will run different wrkflws on schedule time?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
Can we create a Integration service without a Repository service and vice versa?
How to delete duplicate row using informatica?
what is diff between grep and find
How to extract the informatica rejected data?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
Which gives the more performance when compare to fixed width and delimited file ? and why?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
Can we insert and update a target table without using update strategy transformation?How?