How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 28053 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / venkat
S->S.Q->Aggr->Rtr->T1
->T2
Where Aggr take group by option
Rtr group1 condition reccount>1..........>T1
Rtr default group to....................>T2
T1 records are unic records
T2 records are duplicate records
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the sql query overwrite in source qualifier in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
what is the -ve test case in your project.
How can we improve session performance in aggregator transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to load last n records of file into target table - informatica
generate date / time dimension in informatica
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain sql transformation in script mode examples in informatica
What the difference is between a database, a data warehouse and a data mart?
What is a transaction control transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the difference between a connected look up and unconnected lookup?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
what is Active lock explain
