Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swetha
you can Debug U'r maping in maping designer
yoU can view the work space over the entire screen
The designer displays a new icon for a invalid mapings in
the navigator window
yoU can use a dynamic lookup cache in a lokup transformation
Create maping parameters or maping variables in a maping or
maplet to make mapings more flexible
yoU can export objects into repository and import objects
from repository.when u export a repository object, the
designer or server manager creates an XML file to describe
the repository metadata.
The designer allows u to use Router transformation to test
data for multiple conditions. Router transformation allows u
route groups of data to transformation or target.
yoU can use XML data as a source or target.
Server Enahancements:
----------------------
yoU can use the command line program pmcmd to specify a
parameter file to run sessions or batches. This allows you
to change the values of session parameters, and mapping
parameters and variables at runtime.
If you run the Informatica Server on a symmetric
multi-processing system, you can use multiple CPUs to
process a session concurrently. You configure partitions in
the session properties based on source qualifiers. The
Informatica Server reads, transforms, and writes partitions
of data in parallel for a single session. This is avialable
for Power center only.
Informatica server creates two processes like loadmanager
process,DTM process to run the sessions.
Metadata Reporter: It is a web based application which is
used to run reports againist repository metadata.
yoU can copy the session across the folders and reposotories
using the copy session wizard in the informatica server manager
With new email variables, you can configure post-session
email to include information, such as the mapping used
during the session.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Can u generate reports in Informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is a transaction control transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Differentiate between source qualifier and filter transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
explan ur project architecture?
What is incremental aggregation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Is it possible to use a client with different version than that of its Informatica server?
What is mapping debugger?
What is Session and Batches?
What is the need of etl tools?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
