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
- 18694 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
What is the fact table?
Have you worked with/created Parameter file
Explain the types of transformations?
what is diff b/t sorter t/r and agg have the option sorter property...
What is domain in terms of informatica?
What is the procedure for creating independent data marts from informatica 7.1?
What is flashback table ? Advance thanks
Design a mapping to load the cumulative sum of salaries of employees into target table?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
what is informatica metadata?
How can one identify whether mapping is correct or not without connecting session?
What are the static cache and dynamic cache in informatica?
What are the limitations of joiner transformation?
What is informatica etl tool?
