Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 41169 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
sq-->Aggregator-->Router-->target
select group by for port name empno
in aggregater t/r take 1 output port and give condition like
select group by for port name empno
varcount---->count(*)
connect this one router and in router take 2 groups and
give condition like
uniqe_record :varcount=1-----for unique
duplicate_record :varcount>1 ----for duplicate
and connect that groups to target.
u will get result.
| Is This Answer Correct ? | 7 Yes | 10 No |
Post New Answer View All Answers
Mention a few design and development best practices for informatica?
Separate from an archive server and a powerhouse?
generate date / time dimension in informatica
What is standalone command task?
What are the limitations of joiner transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How can we use mapping variables in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
Can you generate sequence numbers without using the sequence generator transformation?
What is the function of aggregator transformation?
Explain the features of connected and unconnected lookup.
Explain pushdown optimization and types in informatica
Explain the code page compatibility?
What is the Rank index port in Rank transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
