|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares Latest Answer : Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which both the PowerCenter Client and Server can connect. ... Informatica server log: Informatica server(on unix) creates a log for all status and error messages(default name: pm.server.log).It also creates an error log for error messages.These files will be created U can Debug U’r maping in maping designer U can view the work space over the entire screen The designer displays a new icon for a invalid mapings in the navigator window U can use a dynamic lookup Latest Answer : DMLs can be used against view (if they are based on 1 table with no aggr funs) ... Read Answers (21) | Asked by : sarath How to view and Generate Metadata Reports(for a particular session would like to generate a report which shows source table , source column and related target table , target column) in informatica? View Question | Asked by : Prem kumar Tags : Metadata What is a view? How it is related to data independence?And what are the different types of views,and What is a view? How it is related to data independence?And what are the different types of views,and what is Materialize view Read Answers (2) | Asked by : goutam Latest Answer : hi view direct connect to tableit wont contain data and what we ask it will fire on table and give the data.ex: sum(sal).materilized view are indirect connect to data and stored in separte scheema. it is just like cube in dw. it will have data. what ever ... Latest Answer : Materialized view stores the result set of a query, but normal view does not store the same. We can refresh the Materialised View when any changes are made in the master table. Normal view is only for view the records. We can perform DML operation ... Latest Answer : Yaa we can refresh materialized view. While creating of materialized views we can give options such as refresh fast and we can mention time so that it can refresh automatically and fetch new data i..e updateed data and inserted data. For active dataware ... Latest Answer : used in oracle to simplify queriesex: select rowid from (select ename from emp group by sal) where rowid Read Answers (2) | Asked by : prasadw
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
