-
Retrieve only Distinct Record from 'flatfile' Source
How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it posible? How?
sheeladere
- Jan 5th, 2010
We can use Aggregate transformation for this. Group by on all the columns in the Aggregator and get only first or last record from the group, it will give you distinct records.But sorter is the best option, I am not sure why you want to avoid it, is there any specific reason?
jsrprasad0402
- Sep 22nd, 2009
Create a Variable port for all the input port and keep them in a seequence that the variable ports will access first after the input port. Then, compare the same variable ports in the ouput port along...
-
What will be the way to send only duplicate records to the Target?
sheeladere
- Dec 30th, 2009
If you want to directly get the records from some relational table then you can use the query in Source qualifier to group by on all the columns and get the count of records and pass the records which...
sanjeev
- Aug 6th, 2007
If you take a ex:EMP TABLE having the duplicate recordsThe query isSELECT *FROM EMP WHERE EMPNO IN SELECT EMPNO FROM EMP GROUP BY EMPNO HAVING COUNT(*)>1;Sanjeeva Reddy
-
Importing data through fixed-width wizard
When importing data through fixed-width wizard, how will u distinguish between different columns if the file is of multiple lines terminated by a n character.
sheeladere
- Jan 4th, 2010
In the Fixed width file, the columns will be allotted with some specific length( fixed width), suppose your file contains 5 columns and total length of the file record is 100, then while defining...
Motilal
- Jun 30th, 2006
Ya.. Can anybody please give any suggestions?I think the source file needed to be cleaned manually
