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
- 10045 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 transaction control transformation in informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Mention few power centre client applications with their basic purpose?
What is the difference between informatica 7.0 and 8.0?
How many dimensions are there in informatica?
What is standalone command task?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the static cache and dynamic cache in informatica?
Differentiate between sessions and batches?
How to create Target definition for flat files?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is repository manager?
What are the types of data warehouses?
What is the maplet?
