What is the difference between a table and the materialized
view?
Answer Posted / chandra
TABLE: A TABLE IS HAVING ALL THE COLUMS DATA
WHERE AS
MATERILIZED VIEW : HAVING SELECTED COLUMS DATA WHICH R
DEFINED IN VIEW
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the different options available for update strategy?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the types of caches in lookup?
On which transformations you created partitions in your project?
How to do the error handling of if ur source is flatfiles?
What is sequence generator transformation in informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what is INFORMATICA TESTING process
What is the commit type if you have a transaction control transformation in the mapping?
How many types of sessions are there in informatica.please explain them?
What is informatica powercenter repository?
How to elaborate powercenter integration service?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .