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
- 7134 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
Explain the pipeline partition with real time example?
Which version configuration tool used in ur project?
What is the different lookup cache(s)?
Which transformation should we use to normalise the COBOL and relational sources?
What is a node in Informatica?
How to Create a folder using pmrep command?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are Dimensional table?
What is meant by LDAP users?
How does a rank transform differ from aggregator transform functions max and min?
What is a transaction control transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How can informatica be used for an organization?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
