Answer / dilip ingole

BY USING SQL

WITH DATA AS(SELECT NUM,ROWNUM RN ,COUNT(1)OVER() CNT FROM A)
SELECT NUM,RN FROM DATA WHERE RN=1
UNION
SELECT NUM,RN FROM DATA WHERE RN=CNT;

Answer / triveni

source->sq->sequencegenerato->expression->filter->target
nextval to expressiontransformation
seq(output) decimal 10 nextval
startval=1,endvalue=14,cycle
mapping variable:$$var varible integer 10 o max
intialvalue=0
filter decimal 10
setvariable( $$seq,($$seq+1))

What is the use of source qualifier?

0 Answers  

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

Which kind of index is preferred in DWH?

3 Answers  

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

---

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

What is the difference between Normal load and Bulk load?

5 Answers  

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---