Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any model difference between ODS and DWH
- 2 Answers
- 7358 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharu_295
ODS is a Replica of transactional data so it is OLTP and DW is an HIstorical Data so its OLAP.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vchandra
ODS stores operational data where as DWH store ODS data as
well as the history of the source database
| Is This Answer Correct ? | 1 Yes | 1 No |
What is sql query override? When did u use sql query override?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
 Informatica Checkpoints
Explian the connected and unconnected lookup transformation
What will be the approach?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
What are the modules in Power Center
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
How the facts will be loaded? explain
What are the advantages of informatica?
Teradata 
