DSXchange

ok i want to encode that data to 0s and 1s
excuse me for not specifying the requirements properly

001,Apoorva,23,M
002,Abhay,24,M
002,roopa,25,M

this is the my input which is stored in the sequential file (example.csv file)

i am passing this example.csv file as input to the encode stage
for this input what we have to specify in the command line of encode stage

ya read the document but was unable to get what to specify in the command line i was trying to encode the data in the sequential file and store the encoded data in another sequential file but i do not know what to specify in the commamd line . give me an example of any sort that serves the objective...

hi guys,

i am new into data stage and had little confussion with the encode stage
can any one explain what arguements to specify in the command line of encode stage with an example

ray.wurlod wrote:

abhay10 wrote:

ray.wurlod wrote:The job design I posted will give you what you want. ...

no it doesnt hold good for more than 2 same duplicate records...

Yes it does. Because ...

i got it using a differnt query, any wayz thanx...

ray.wurlod wrote:The job design I posted will give you what you want. ...

no it doesnt hold good for more than 2 same duplicate records...

HAVING COUNT(*) = 1 gives you the 90 records and HAVING COUNT(*) > 1 gives you the other 10. Isn't that what you wanted? You can do this within DataStage, effectively emulating the HAVING claus ... no it will give 10 records only when each of those 10 records have occured only 2 times, suppose the ...

ray.wurlod wrote:

abhay10 wrote:COUNT DOESNT WORK IN DATASTAGE...

Yes it does, when it's done right.

ya, sry for that...

I'm assuming that your table has 3 columns with name col1, col2 and col3. Here is a generic query that meets your requirement... SELECT col1, col2, col3, count(*) as Count FROM tab_name GROUP BY col1, col2, col3 HAVING COUNT(*)>1 In the Database stage in your DS job, define four columns - col1, col...

Assuming that 'databases' mean 'tables' from your statement "i hav 2 databases...". You can find the duplicate records without actually relating (e.g. join) the two tables, by firing the appropriate SQL statement against the table that has duplicate rows. pls post that sql statement that ...

Karine wrote:It would be easier to run a query against your first database with a query like:

SELECT COL1 FROM DBASE GROUP BY COL1 HAVING COUNT(*) > 1

assuming col1 is your unique key

COUNT DOESNT WORK IN DATASTAGE...

i hav 2 databases first includes duplicates data and second one after removing duplicate data
eg first one contain 100 records and second one 90 records
and 10 are the duplicate entries, i want to find these 10 entries, how to do that?

thanks everyone i got it by concatenating space using left and right...

If you want to execute the substring operation through transformer then below is an example what you can refer. Input1 - column name expression in the transformer stage expression editor. Input1[1,3] note: 1 is the starting position and 3 is the string length. if your Input1 data is "SUBSTRING...

ray.wurlod wrote:Using the appropriate functions in a Modify stage or a Transformer stage. ...

i know that, but which function?