Interested to Buy Any Domain ? << Click Here >> for more details...
How do you remove duplicate records in informatica?
- 1 Answers
- 1365 Views
- I also Faced
- E-Mail Answers
Answer Posted / lahari
There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load only null records into target? Explain through mapping flow.
How can repository reports be accessed without sql or other transformations?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Can informatica load heterogeneous targets from heterogeneous sources?
How to create Target definition for flat files?
Can we create two repositories on same database instance in oracle?
How would you join a node to the already existing domain?
What is the need for an etl tool?
Explain about Informatica server process that how it works relates to mapping variables?
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
generate date / time dimension in informatica
During the running session, output files are created by informatica server. Enlist few of them.
What is depict expression change?
How can we use batches?
What does reusable transformation mean?
