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
- 6771 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
scenario where i can use only concurrent execution of workflow.
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 is parallel processing in informatica?
how to create user defined function (udf) in informatica
What is a surrogate key?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the types of presistent cache in look up tr.
Define joiner transformation?
What is a standalone command task?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the session task and command task?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What do you mean by enterprise data warehousing?
How to load the data from people soft hrm to people soft erm using informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
