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 differences between oltp and olap?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Parameter and variable differences
Why is sorter an active transformation?
What is pmcmd command?
Please let me know how to make encryption and decryption with example?
Enlist the tasks for which source qualifier transformation is used.
Difference between Target-based loading and constraint-based loading?
How to create the source and target database connections in server manager?
What is a mapplet/worklet in informatica?
what is the hint? how to use it to reduce the query processing in program?
What does cheating measurement mean?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How do you convert single row from source into three rows into target?
What is source qualifier transformation in informatica?