how to get max value record into one target and remaining
records into another target?
Answer Posted / informatica
use a sorter and do a descending sort. calculate the row_id.
pass it to a router. 1 group condition will be row_id=1.
2nd group row_id >1.1st group to one target instance. 2nd
group to another target instance.
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What are the databases that informatica can connect to windows?
what is unit testing?tell me proceedure
Define update strategy?
What is DR strategy for Informatica project?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a shortcut and copy in Informatica and how two are different with each other?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Is there any way to read the ms excel datas directly into informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is difference between a gateway node and worker node?
What is lookup change?
How many input parameters can exist in an unconnected lookup?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How can we delete duplicate rows from flat files?