Kwalling All Informatica Guys

[csk]

[warr49er]

[quote name='jaffanajeffada' timestamp='1337195139' post='1301809201']
count anedhi column anukuntunna bayya, aggregate value kaadhu ani anipistundhi!!

three conditions apply avvali ante 3 variable ports kaavali kadha!! i mean, first condition apply ayinappudu count value okati untundhi, and second condition kooda match aithe first condition unna value ki 1 add cheyyali kadha... aa case lo multiple variable ports kavali ani anukuntunna!
[/quote]


count is not a column... ee calculation kosam variable la create chesanu....each row lo aa three conditions base chesukoni percent calculate chesi inko column lo insert cheyali....calculation kosam count use chestunna...

[ganesh]

[quote name='warr49er' timestamp='1337202012' post='1301810313']



count is not a column... variable....each row lo aa three conditions base chesukoni percent calculate chesi inko column lo insert cheyali....calculation kosam count use chestunna...
[/quote]count = ?

[jaffanajeffada]

[quote name='warr49er' timestamp='1337202012' post='1301810313']
count is not a column... variable....each row lo aa three conditions base chesukoni percent calculate chesi inko column lo insert cheyali....calculation kosam count use chestunna...
[/quote]

aithe aggregator lone cheyyochu anukunta bayya.... count function undhi kadha, daanlo condition ivvochu!

some thing like COUNT(*, [color=#282828][font=helvetica, arial, sans-serif][size=3]family = na[/size][/font][/color] )

refer to COUNT function in Informatica help

[warr49er]

[quote name='jaffanajeffada' timestamp='1337202812' post='1301810397']

aithe aggregator lone cheyyochu anukunta bayya.... count function undhi kadha, daanlo condition ivvochu!

some thing like COUNT(*, [color=#282828][font=helvetica, arial, sans-serif][size=3]family = na[/size][/font][/color] )

refer to COUNT function in Informatica help
[/quote]


thanks Jaffabhai...

[jaffanajeffada]

[quote name='warr49er' timestamp='1337203756' post='1301810440']
thanks Jaffabhai...
[/quote]


let me know if that works,

aggregator lo kooda variable ports open chesi ee calculations chesukochu!!

[vokatonumberkurrodu]

[quote name='jaffanajeffada' timestamp='1337202812' post='1301810397']

aithe aggregator lone cheyyochu anukunta bayya.... count function undhi kadha, daanlo condition ivvochu!

some thing like COUNT(*, [color=#282828][font=helvetica, arial, sans-serif][size=3]family = na[/size][/font][/color] )

refer to COUNT function in Informatica help
[/quote]

aggregator lo count vadithe number of records count istundhi....

based on scenario thats not what he needs... he needs to find out dqp based on a set of fields in a single record.

so v_count = 0 (initial)
check1 port to check condition1 is true. count = count +1, else 0
check2 port to check if check1 is true and condition2 is true count = count + 1, else 0
check3 port to check if check2 is true and condition3 is true count = count+1 else 0
dqp = (check1+check2+check3)/3 * 100

comments???

[jaffanajeffada]

[quote name='vokatonumberkurrodu' timestamp='1337204404' post='1301810480']
aggregator lo count vadithe number of records count istundhi....

based on scenario thats not what he needs... he needs to find out dqp based on a set of fields in a single record.

so v_count = 0 (initial)
check1 port to check condition1 is true. count = count +1, else 0
check2 port to check if check1 is true and condition2 is true count = count + 1, else 0
check3 port to check if check2 is true and condition3 is true count = count+1 else 0
dqp = (check1+check2+check3)/3 * 100

comments???
[/quote]

only one suggestion, use variable ports for the calculation or different aggregators for each condition check

using variable ports is preferred!

[jaffanajeffada]

[quote name='vokatonumberkurrodu' timestamp='1337204404' post='1301810480']
aggregator lo count vadithe number of records count istundhi....

based on scenario thats not what he needs... he needs to find out dqp based on a set of fields in a single record.

so v_count = 0 (initial)
check1 port to check condition1 is true. count = count +1, else 0
check2 port to check if check1 is true and condition2 is true count = count + 1, else 0
check3 port to check if check2 is true and condition3 is true count = count+1 else 0
dqp = (check1+check2+check3)/3 * 100

comments???
[/quote]
by the way, first time choostunna mee id ni... kothaga join ayyara?/

[warr49er]

Thank you all...

jaffanajeffada
vokatonumberkurrodu
Terminator II
mtkr
ganesh

expression validate aindhi...2mrw or day after testing ki potundhi...
akkada emaina theda vaste malli kwalling ani thread vesta...

[jaffanajeffada]

[quote name='warr49er' timestamp='1337218133' post='1301811516']
Thank you all...

jaffanajeffada
vokatonumberkurrodu
Terminator II
mtkr
ganesh

expression validate aindhi...2mrw or day after testing ki potundhi...
akkada emaina theda vaste malli kwalling ani thread vesta...


[/quote]
expression validate avutundhi but data validate chesukunnava?? unit testing??

[ganesh]

[quote name='jaffanajeffada' timestamp='1337260822' post='1301812915']

expression validate avutundhi but data validate chesukunnava?? unit testing??
[/quote]naku adee doubt [img]http://1.bp.blogspot.com/-vXer8MQYZrM/T1jw_Q2juqI/AAAAAAAAB_g/Upm7DId5ox0/s1600/brahmi+laugh.gif[/img]