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
- 9835 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
What are the differences between source qualifier and joiner transformation?
What are the different lookup cache(s)?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is event and what are the tasks related to it?
What is lookup change?
What do you mean by filter transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What is intricate mapping?
In informatics server which files are created during the session rums?
Differentiate between reusable transformation and mapplet.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the different ways to implement parallel processing in informatica?
Target increases every day even though no new record was inserted
How to do unit testing in informatica?
Implementation methodology
