Interested to Buy Any Domain ? << Click Here >> for more details...
how to get max value record into one target and remaining
records into another target?
- 2 Answers
- 9558 Views
- Accenture, I also Faced
- E-Mail Answers
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 reusable transformations?
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 ?
Explain direct and indirect flat file loading (source file type) - informatica
what is the difference between informatica6.1 and infomatica7.1
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How do you load unique records into one target table and duplicate records into a different target table?
Could you explain what is enterprise data warehouse?
What is main use of mapplet?
permutations of mapplet
Plz can any one say me how to get the informatica certification materials and dumps
What is xml source qualifier transformation in informatica?
Explain scd type 3 through mapping.
What are the tasks that source qualifier perform?
What is rank transformation?
Define sessions in informatica etl?
