Interested to Buy Any Domain ? << Click Here >> for more details...
How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 9922 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / babu
u can write the filter condition in filter t/r.
in aggregator t/r select all ports are group by and add one
out put port,that is out--count(*),
in filter t/r u cam place the condition is out=1;
mapping:
src->sq->agg(t/r)->filtr or router t/r->trg
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
design of staging area?
What is a pre-defined event and user-defined event?
What is workflow manager?
Explain informatica architecture - version 8 / 9
What are the components of Informatica? And what is the purpose of each?
What are the main issues while working with flat files as source and as targets ?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What will be the approach?
How do you load unique records into one target table and duplicate records into a different target table?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is exclusive and normal mode for repository services?
How to convert multiple rows to single row (multiple columns) in informatica
What is standalone command task?
What are the restrictions of union transformation?
Mention few power centre client applications with their basic purpose?
