What is the difference between view and materialised view?
Answer Posted / yaseen
Rowid of view and table is same
Rowid of M.view and table is different
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
4 yrs etl devloper roles and responsibilities?any body give solutions
Describe an informatica powercenter?
How do you promote a non-reusable transformation to reusable transformation?
Different circumstance which drives informatica server to expel records?
Have you worked with/created Parameter file
Can we override a native sql query within informatica?
What will be the approach?
How can you differentiate between powercenter and power map?
How might you approve all mappings in the archive all the while?
Explain what is informatica metadata and where is it stored?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to update a particular record in target with out running whole workflow?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance