how to load first record of first time run,second record to 2nd time n 3rd recor

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

Question Posted / srinivasan.palle

2 Answers
6518 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to t..

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;

Is This Answer Correct ?

0 Yes

0 No

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to t..

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

Is This Answer Correct ?

1 Yes

3 No

Post New Answer