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
- 41274 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
data flow for this one is:
sq-->Aggregater-->Router-->target
in aggregater t/r take 2 output ports and give condition like
uniqe_port---->count(*)=1
duplicate_port--->count(*)>1
connect this one router and in router take 2 groups and
give condition like
uniqgroup=uniqe_port
duplicategroup=duplicate_port
and connect that groups to target
| Is This Answer Correct ? | 15 Yes | 28 No |
What is a look up function? What is default transformation for the look up function?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
What is the use of source qualifier?
How to fix the etl bugs..Tell me the process?
How can informatica be used for an organization?
What is the function of look up transformation?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
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.
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
Explain pushdown optimization and types in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Teradata 
