Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh
if the source is database means we can delete the duplicate
records by enabling the option select distinct in source
qualifier t/r properties or by writing the following query
in source qualifier filter
delete from emp where rowid not in (select min(rowid) from
emp group by empno);
if the source is flat file means by enabling the option
distinct in sorter t/r we can delete the duplicate records
| Is This Answer Correct ? | 27 Yes | 1 No |
Post New Answer View All Answers
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to load the data from people soft hrm to people soft erm using informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain direct and indirect flat file loading (source file type) - informatica
What is aggregate cache in aggregator transformation?
What is depict expression change?
What is the Rank index port in Rank transformation?
Why do you use Mapping Parameter and mapping variable?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
server hot-ws270 is connect to Repository B. What does it mean?
What is Cognos script editor?
What is domain and gateway node?
What is standalone command task?
