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.

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

Can you use flat files in Mapplets.

0 Answers  

---

what is SDLC way of code development?

0 Answers  

---

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

---

How do you do error handling in Informatica?

1 Answers  

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

---

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

How do you implement scheduling in Informatica?

1 Answers  

---