Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 7971 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
by using only filter t/r we cannot delete duplicate records.
but by using combination of aggrigator and filter t/r we can achive it
in aggrigator t/r create a new o/p port to count_rec with expression count(key column)
connect all the ports to filter and write a condition count_rec=1.now connect ports to the target
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the commit type if you have a transaction control transformation in the mapping?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
server hot-ws270 is connect to Repository B. What does it mean?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the differences between joiner transformation and source qualifier transformation?
What is InformaticaPowerCenter?
What are the differences between oltp and olap?
Can you use flat files in Mapplets.
What is enterprise data warehousing?
is it possible to index the data in cache of lkp transformation ?
What are the popular informatica products?
what is Active lock explain
What is decode in static cache?
