In Which scenario did u used Incremental loading?
Answers were Sorted based on User's Feedback
Whenever your record changes and any date column get
updated in source.This happens in mainly transactions where
amount or balance changes.This record is flagged based on
the the date colum which isnow changed and value become
greated then session run time when it was executed
previously.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramu
for capturing the changed data in source we use the
incremental loading.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
What is junk dimention?
What is sorter transformation?
How to run a session, which contains mapplet?
What is the difference between Power Centre and Power Mart?
How will the document be delivered to me?
Could any one to tell Fact table Partitioning?
Explain the etl program with few examples.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?