Interested to Buy Any Domain ? << Click Here >> for more details...
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
- 2 Answers
- 7303 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
What is aggregator transformation in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain the pipeline partition with real time example?
What is the difference between router and filter?
What are the differences between source qualifier and joiner transformation?
Explain what are the different types of transformation available in informatica.
Why do we need informatica?
What do think which one is the better joiner or look up?
What is InformaticaPowerCenter?
What are the different components of powercenter?
where to store informatica rejected data?
What you know about transaction control transformation?
what is INFORMATICA TESTING process
What is the meaning of up gradation of repository?
