Answer / nitin

The one way to skip records for relational sources would be
adding a SQL Query in session properties.

SELECT * FROM EMPLOYEE
MINUS
SELECT * FROM EMPLOYEE WHERE ROWNUM <= 5
This query would skip the first 5 records.

When will you use SQL override in a lookup transformation?

1 Answers  

---

How does the session recovery work.

1 Answers  

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

---

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

What are parallel querys and query hints?

1 Answers  

---

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

---

What is a command that used to run a batch?

4 Answers  

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,

---