Interested to Buy Any Domain ? << Click Here >> for more details...
how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 18453 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajit kumar pradhan
if it is a relational source then click on source Qualifier
properties then check Distinct option.
if it is a flat file then it can't work .......
click on target defination select target menu and click
generate/execute then it come out one dialog box come out
then check primary key check box..it avoid duplicale row...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Performance tuning in UNIX for informatica mappings?
can we override a native sql query within informatica? How do we do it?
Design time, run time. If you don't create parameter what will happen
How can we store previous session logs?
have u done any performance tuning? how u ll do?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to do the error handling of if ur source is flatfiles?
How to start a workflow using pmcmd command?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is a mapplet/worklet in informatica?
What is a node in Informatica?
What is informatica worklet?
