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
- 9593 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / swarup
sorter(key=requiredkey)
expression
router=1stgrp(o_cnt=1),2nd grp(o_cnt>=1)
| Is This Answer Correct ? | 1 Yes | 0 No |
How to load data in informatica ?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What are the settings that you use to configure the joiner transformation?
How many repositories can we create in Informatica??
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Briefly define a session task?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
why do we go for update strategy tr in SCD rather using the session properties?
Teradata 
