Interested to Buy Any Domain ? << Click Here >> for more details...
How can we eliminate duplicate rows from flatfile,explain?
- 3 Answers
- 11828 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagaraj.g
using sorter transformation for distinct in a flat files
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / veera reddy
By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / seshagiri
veere reddy,
Dynamic lookup will not work for flat file only static
lookup will work for a flat file
| Is This Answer Correct ? | 2 Yes | 3 No |
What is meant by target load plan?
what is parallel querying and what r hints.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
If informatica has its scheduler why using third party scheduler?
what is diff between IN and EXIT commands
What is a look up function? What is default transformation for the look up function?
What is the maplet?
How might you approve all mappings in the archive all the while?
What are the designer tools for creating tranformations?
Why we use ENABLE HIGH PRECISION in session properties?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
Teradata 
