Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 5716 Views
- IBM, I also Faced
- E-Mail Answers
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 |
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
Can you copy the batches?
Which files are created during the session rums by informatics server?
How do you load only null records into target? Explain through mapping flow.
Define mapplet?
How to compare Source and Target table, without using dynamic lookup?
Without using Lookup & Sequence Generator, How to generate Sequence?
how can we use sorter transformation in joins?
What is batch and describe about types of batches?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
how to join two flat files in informatica?
Teradata 
