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
- 41268 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / chetan
I/p
A
B
B
C
D
D
need to load A.C in one tgt and B,B,D,D in another target table.
SQ o/p should be given to aggregator. group by first column.create another port(v_count) with count(*).
SQ o/p should be passed to joiner to join aggr and SQ(source).
o/p looks like after joinning
A 1
B 2
B 2
C 1
D 2
D 2
use router to route v_count=1 and v_count=2 to different targets.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
can anyone explain me about retail domain project in informatica?
What are the advantages of using informatica as an etl tool over teradata?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is a transaction control transformation?
where to store informatica rejected data?
What is rank transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Differentiate between a database and data warehouse?
How is union transformation utilized?
What do you understand by term role-playing dimension?
What is joiner transformation in informatica?
What are the types of presistent cache in look up tr.
