count for no of rows
Posted: Thu Jan 19, 2006 1:01 am
Hi
I have scenario where i need to get number of rows for the same composite primary key
the mapping goes like this
I have scenario where i need to get number of rows for the same composite primary key
the mapping goes like this
Code: Select all
ODBC1--->TRANSFORMER---->ODBC2---->HASHFILE1
^
|
|lkp
|
HASHFILE1
Iam having 3 keys in my target odbc2 seen1 | sean2 | jrnl_lines
seen1 and seen 2 comes from the source odbc1 and jrnl_lines is not comming from the source .
for jrnl_lines i need to populate with number of times the same composite key is repeating
for example if for the first time seen1 and sean2 are like a1 and a2 the the value fro jrnl _lines must be 1 and if the same record comes again from the source as a1 and a2 the value must be 2 for jrnl lines
i must get count for it
is there any way that i can code for this can any one help me