Whatis the difference between View and Materialized View ?
Answer Posted / the tiklu
Materialized View is for Consumerist es, while Views
are for great men and sexy women.
| Is This Answer Correct ? | 7 Yes | 46 No |
Post New Answer View All Answers
How can we create index after completion of load process?
What is the surrogate key?
Explain lookup transformation in informatica
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Differentiate between sessions and batches?
scenario where i can use only concurrent execution of workflow.
What is the advantage of informatica?
How many ways are there to do 'remove duplicate records in informatica'?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are active transformations.
Is it possible to use a client with different version than that of its Informatica server?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is rank transform?
How to update a particular record in target with out running whole workflow?