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 |
what are the row and column separations in Flat Files
Have you worked with/created Parameter file
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain scd type 3 through mapping.
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
What is a shortcut and copy in Informatica and how two are different with each other?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
What is power play plug in?
Explain direct and indirect flat file loading (source file type) - informatica
How to read data from flat file source if the data is in paragraph format?