Answer / swetha

yoU can use command line arguments for a session or
batch.This allows yoU to change the values of session
parameters,and mapping parameters and maping variables.

Parallel data processig: This feature is available for
powercenter only.If we use the informatica server on a SMP
system,yoU can use multiple CPU's to process a session
concurently.

Process session data using threads: Informatica server runs
the session in two processes.

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

---

Kimball and Inmon methodologies?

2 Answers  

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

How many cubes create from a single model?

1 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---