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
- 7425 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
Enlist the differences between database and data warehouse.
What are junk dimensions?
What is meant by incremental aggregation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to create a non-reusable instance of reusable transformations?
Informatica Checkpoints
Mention few advantages of router transformation over filter transformation.
Can you use flat files in Mapplets.
What are the types of presistent cache in look up tr.
Make a note of the quantity vaults made in informatica?
Enlist the tasks for which source qualifier transformation is used.
Differences between version 7.x and 8.x.
Explain sessions?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Informatica settings are available in which file?
