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
- 9718 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 do unit testing in informatica?
Hi experts, can anyone tell how much we use plsql in real time
What are the ETL tools available in DWH?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
What is the target load order?
how to load only the first and last record of a flat file into the target?
can any one explain me about junk dimension
What is different between informatica version 8 and 9 version
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
Define joiner transformation?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
What is a snowflake schema?
Teradata 
