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))

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

what are surrogate keys?

5 Answers  

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

scenario

1 Answers  

---

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

What is difference macros and prompts?

2 Answers  

---

What is target update override

2 Answers   CTS,

---

what is hash table in informatica?

1 Answers   Zensar,

---