Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

Which transformation should u need while using the cobol sources as source defintions?

2 Answers  

---

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

---

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

In warehouses how many schemas are there?

0 Answers  

---

How to create or import flat file definition in to the warehouse designer?

0 Answers   Informatica,

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---