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
- 10093 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
Explain about cumulative Sum or moving sum?
How to create or import flat file definition in to the warehouse designer?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you handle two sessions in Informatica
What is the function of look up transformation?
How do you change a non-reusable transformation to reusable transformation?
What are the differences between joiner transformation and source qualifier transformation?
What is the difference between informatica 7.0 and 8.0?
What are the prerequisite tasks to achieve the session partition?
What is an aggregator transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How many ways a relational source definition can be updated and what are they?
How do you set a varible in incremental aggregation
In which transformation you cannot drag ports into it?
Explain lookup transformation in informatica
