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
- 18392 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishnakanthch
We can use the option 'SELECT DISTINCT' in the source
qualifier.
Anybody please tell me whether this works or not.
| Is This Answer Correct ? | 5 Yes | 23 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Performance tuning( what you did in performance tuning)
Differentiate between a database and data warehouse?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is status code in informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
How does a sorter cache works?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Name the different lookup cache(s)?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the use of transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Can you use flat files in Mapplets.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
