how will you remove the duplicate records from flat file
without using sorter?
- 7 Answers
- 17442 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
whats the logic to load the lower level of granularity of data to fact table.
Mention some types of transformation?
r u done any partitions in ur project?
waht type of interface is used for testing the data in informatica
Can we create multiple integration service on single repository?
How do you update the records with or without using update strategy?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What differs when we choose the sorted input for aggregator transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Repository user profiles
Explain load alternative records / rows into multiple targets - informatica
What are the new features of informatica 9.x in developer level?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
can anyone suggest best free Talend data integration training online
What is a filter transformation and why it is an active one?
