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
- 41710 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 do you mean by filter transformation?
Have you worked with/created Parameter file
Can I create one wrkflw which will run different wrkflws on schedule time?
sample mappings for scd1,scd2 and scd3
how to improve performence by using sorted input in aggrigator t/r.
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
Explain lookup transformation source types in informatica
Is it possible to have "5 source & 5 Target" in single mapping?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the different types of transformation available in informatica.
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
major difference between normal loading and bulk loading?
Teradata 
