Answer / guest

we use lookup transformation to lookup data in a relational
table ,view or synonym.and by using lookup transformation
we can perform the following jobs
-to get the related value
-to perform the calculations
-to update the slowy changing dimentions

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---

What are data-driven sessions?

0 Answers  

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

Differentiate between joiner and lookup transformation?

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  

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

Write the different tools in the workflow manager?

0 Answers  

---

What are active transformations? Name them.

1 Answers  

---

In dimension and fact table? which one holds big data?

2 Answers  

---