Answer / gangam rajesh

Bridge table is a association table between two multivalued
dimension tables i.e. which have many to many relation.
Actually database doesn't support m to m relationship so
by using this bridge table we convert the m to m relation
ship into two 1 to many relationships.Bridge table contains
primarykeys of both dimensional tables as a compositekey

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

What is staging area?

11 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  

---

In informatica workflow manager, how many repositories can be created?

0 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

---