How to delete duplicate records in a flat file source?
- 2 Answers
- 7769 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
conncet the flat file to sorter transformation and select
distinct option.
| Is This Answer Correct ? | 17 Yes | 6 No |
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 |
what is materialized view?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
what is $$$$?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what is surrogate id ?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is the location of parameter file in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is galaxy shema
Teradata 
