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.

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

How do you handle decimal places while importing a flatfile into informatica?

1 Answers  

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

What is a dimensional model?

0 Answers  

---

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

---

how many types of dimensions are available in informatica?

0 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

How many number of sessions can one group in batches?

0 Answers  

---

What is a connected transformation?

0 Answers   Informatica,

---

Why is sorter an active transformation?

0 Answers  

---

What is workflow? What are the components of the workflow manager?

0 Answers  

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---