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
- 7319 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 is SDLC way of code development?
Explain pushdown optimization and types in informatica
What is a filter transformation and why it is an active one?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
can u any challenge your project?
Target increases every day even though no new record was inserted
What is the benefit of session partitioning?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What could be the possible resons of locks by user?
What is mapping debugger?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the types of lookup transformation?
Where are the source flat files kept before running the session?
How can we delete duplicate rows from flat files?
