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
How to create a non-reusable instance of reusable transformations?
generate date / time dimension in informatica
What is incremental aggregation?
What is meant by incremental aggregation?
How can we use mapping variables in informatica?
define galaxy repository in informatica
What is depict expression change?
What is a grid in Informatica?
How many ways are there to create ports?
Explain the scenario which compels informatica server to reject files?
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 Session and Batches?
What are the differences between a connected lookup and unconnected lookup?
Does an informatica transformation support only aggregate expressions?
Explain the different kinds of facts.
