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.

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

Explain the types of lookup transformation?

0 Answers  

---

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

---

Whats there in global repository

0 Answers  

---

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

How can u stop a batch?

2 Answers  

---