Answer / abhishek.x.upadhyay

A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.

Answer / qamar

I suppose the answer to this question is by using Joiner
transformation.

how can we calculate fact table size?

1 Answers  

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

What are the features of complex mapping?

0 Answers  

---

What is a node in Informatica?

0 Answers  

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

How will you convert rows into columns or columns into rows

1 Answers  

---

what is casual dimension?

6 Answers   IBM,

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

How informatica process data means how informatica works?

2 Answers   TCS,

---

What is a joiner transformation and why it is an active one?

0 Answers  

---