How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 37477 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 |
Explain about Informatica server process that how it works relates to mapping variables?
How will you convert rows into columns or columns into rows
why union is active transformation?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
How to eliminate duplicates from flat file..what is the procedure
what is the main advantage of unconnected lookup
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
how we load the data from source to staging area
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
what are types of dimentions?
Three date formats are there . How to change these three into One format without using expression transformation ?
What is informatica worklet?
Teradata 
