What are the new features in Informatica 5.0?
- 1 Answers
- 4090 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How many input parameters can exist in an unconnected lookup?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to extract original records at one target & Duplicate records at one target?
1 lac of flat fles in source how to load target at a time?
what are types of dimentions?
can we have to do changes in session property when we are dynamically generating target files?
Do joiner transformation use cache? If so describe?
How can you access the remote source into your session?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
How can repository reports be accessed without sql or other transformations?
4 yrs etl devloper roles and responsibilities?any body give solutions
Teradata 
