How to delete duplicate records in a flat file source?
Answer Posted / sushanth1234
Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
define galaxy repository in informatica
Where can we find the throughput option in informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Informatica Checkpoints
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 fact table & dimensional table in pharmaceutical and hospotal related products???
what is index?how it can work in informatica
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 is aggregator transformation in informatica?
can u give example for factless fact table
What is resilience time?
What do you mean by enterprise data warehousing?
tell me 5 session failure in real time how can you solve that in your project?
Briefly explain the aggregator transformation?