wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

What is query panel?

1 Answers  

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

What are the differences between a connected lookup and unconnected lookup?

1 Answers  

---

explain about lookup t/r?

1 Answers   IBM,

---

Write the different tools in the workflow manager?

1 Answers  

---

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

2 Answers   IBM,

---