Answer / swetha

Datamovement modes determines how informatcia server handles
the charector data.yoU choose the datamovement in the
informatica server configuration settings.Two types of
datamovement modes avialable in informatica.

ASCII mode

Uni code mode.

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

Separate from an archive server and a powerhouse?

0 Answers  

---

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

---

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---