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
- 7166 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
How to create the source and target database connections in server manager?
What is a grid in Informatica?
Explain scd type 3 through mapping.
Explain lookup transformation is active in informatica
Enlist the various types of transformations.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
In informatics server which files are created during the session rums?
What is a repository? And how to add it in an informatica client?
Describe data concatenation?
How to use pmcmd utility command?
What is a rank transform?
What is event and what are the tasks related to it?
Explain lookup transformation in informatica
What are the different clients of powercenter?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
