how remove 1st 3 records & last 3 records in informatics
Answer Posted / davankumar p
2 pipelines,1st pipeline sorter t/r ascending order then
rank t/r top3
2nd pipeline sorter decending order then rank top3 t/r
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
What are the different versions of informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
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.
Which transformation should we use to normalise the COBOL and relational sources?
Is stop and abort are same in informatica?
How do you load only null records into target? Explain through mapping flow.
What is a connected transformation?
How can we update a record in the target table without using update strategy?
Explain sessions. Explain how batches are used to combine executions?
What are the performance considerations when working with aggregator transformation?
how to load rows into fact table in data warehouse
What are session parameters ? How do you set them?
Could you explain what is enterprise data warehouse?
What is a node in Informatica?
How can you define user defied event?