| Author |
Message |
    
Tingari_xx
Bewarse Legend
Username: Tingari_xx
Post Number: 41647
Registered: 08-2006
Posted From: 205.157.110.11
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 10:00 am: |
|
niru ga
client komfateesi bloomberg aa, futures antunnav |
Onlyniru3
Bewarse Legend
Username: Onlyniru3
Post Number: 13525
Registered: 08-2009
Posted From: 216.105.250.4
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 9:59 am: |
|
Stewie:
only forex,futures and parent stewie baaa.... vere vaaatiki inko map vundhi le...... intaka mundhu aa map lo ee forex and futures vundevi.... Ippudu Parent map lo integrate chestunnam.... adnhuke ee tala noppi..
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
|
Stewie
Pilla Bewarse
Username: Stewie
Post Number: 488
Registered: 03-2011
Posted From: 63.138.168.7
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 9:56 am: |
|
ba repu inkoti add ayye chance unda ee
FOREX, FUTURES, PARENT list ki ..
only these 3 will be there ante edanna try cheyachemo..
repodduna forex2 ani inkoti add ayyi adi kuda ravali for TOTAL_DARTS ante mari .. abba dabba jaba..
kothga petta signature ela undi 
|
Onlyniru3
Bewarse Legend
Username: Onlyniru3
Post Number: 13517
Registered: 08-2009
Posted From: 216.105.250.4
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 9:43 am: |
|
Stewie:so ippudu child_acct_id indirectly corresponds to
FOREX, FUTURES, PARENT
yep this is correct baa...
Stewie:so neeku ee kips_name with all the above kavali ..
True...
Stewie:emaina Tree structure type unda nee data ?
-- Parent
TRADE_TRX-- --Future
--forex
Ila emi ledhu baa source lo.. Mind dobbestundhi denemma logic gaaani....
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
|
Sachinfan
Bewarse Legend
Username: Sachinfan
Post Number: 20150
Registered: 10-2010
Posted From: 66.151.103.9
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 9:41 am: |
|
Onlyniru3:enti baa tega alochistunna..... emanna tattindha?
endi tattedi sintakai.. anta pedda post sudagane drop pettesa
gaali puraanam...sollu ki ankitham 
|
Stewie
Pilla Bewarse
Username: Stewie
Post Number: 487
Registered: 03-2011
Posted From: 63.138.168.7
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 9:38 am: |
|
baaga kashtamga undi ba naakaithe..
so ippudu child_acct_id indirectly corresponds to
FOREX, FUTURES, PARENT
so neeku ee kips_name with all the above kavali ..
emaina Tree structure type unda nee data ?
TRADE_TRX
-- Parent --Future --forex
ila emanna unda ?
kothga petta signature ela undi
|
Dobbey
Yavvanam Kaatesina Bewarse
Username: Dobbey
Post Number: 2413
Registered: 03-2011
Posted From: 136.174.187.5
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 9:33 am: |
|
Health is Happiness
|
Onlyniru3
Bewarse Legend
Username: Onlyniru3
Post Number: 13511
Registered: 08-2009
Posted From: 216.105.250.4
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 9:30 am: |
|
Sachinfan:
enti baa tega alochistunna..... emanna tattindha?
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
|
Sachinfan
Bewarse Legend
Username: Sachinfan
Post Number: 20123
Registered: 10-2010
Posted From: 66.151.103.9
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 8:48 am: |
|
gaali puraanam...sollu ki ankitham
|
Onlyniru3
Bewarse Legend
Username: Onlyniru3
Post Number: 13509
Registered: 08-2009
Posted From: 216.105.250.4
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 8:41 am: |
|
Stewie:kpis_dim_key unnaya admin.kpis_dim lo for
TOTAL_DARTS FUTURE?
TOTAL_DARTS_FUTURE tho akarledhu annai... TOTAL_DARTS tho value raavali.... TOTAL_DARTS ki kpis_dim_key vundhi admin.kpis_dim table lo...
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
|
Stewie
Pilla Bewarse
Username: Stewie
Post Number: 486
Registered: 03-2011
Posted From: 63.138.168.7
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 8:37 am: |
|
kpis_dim_key unnaya admin.kpis_dim lo for
TOTAL_DARTS FUTURE?
kothga petta signature ela undi
|
420
Bewarse Legend
Username: 420
Post Number: 12021
Registered: 12-2006
Posted From: 212.159.240.80
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 8:33 am: |
|
bunch of unions should do the damage .. I am on iphone .. cannot type you the answer
Knit India,do not split India !
|
Onlyniru3
Bewarse Legend
Username: Onlyniru3
Post Number: 13507
Registered: 08-2009
Posted From: 216.105.250.4
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, August 17, 2011 - 6:42 am: |
|
While execute this query i get the following output :-
select c.time_id,c.kpis_day_value,c.kpis_name,e.parnt_acct_id,e.relationship_type_name from
(SELECT dr.account_dim_key,dr.time_id,dr.kpis_day_value,kpisms.kpis_name
FROM ids_admin.admin.kpis_day dr
LEFT OUTER JOIN ids_admin.admin.kpis_dim kpisms
ON
dr.kpis_dim_key = kpisms.kpis_dim_key
WHERE
dr.time_id >= '20110718' AND
dr.time_id < '20110719' AND
kpisms.active_indicator = 'YES'
)c
LEFT OUTER JOIN
ids_admin.admin.account_dim d
ON c.account_dim_key = d.account_dim_key
LEFT OUTER JOIN
edw_admin.admin.vw_edw_tda_acct_tos_acct_rel e
ON d.account_identifier = e.child_acct_id
WHERE
e.parnt_acct_id > -1 AND e.child_acct_id > -1 AND parnt_acct_id = '4249917'
ORDER BY
e.parnt_acct_id,c.time_id desc --
time_id, kpis_day_value, kpis_name, parnt_acct_id, relationship_type_name
20110718, 1, TRADE_TRX, 4249917, Forex
20110718, 6, TRADE_TRX, 4249917, Parent
20110718, 6, TOTAL_DARTS, 4249917, Parent
20110718, 6, EQUITY_TRADE_TRX, 4249917, Parent
20110718, 1, FOREX_TRADE_TRX, 4249917, Forex
20110718, 6, EQUITY_DARTS, 4249917, Parent
20110718, 2, TRADE_TRX, 4249917, Futures
But I need the output like this
kpis_day_value, kpis_name, parnt_acct_id, relationship_type_name
1, TRADE_TRX, 4249917, Forex
2, TRADE_TRX, 4249917, Futures
6, TRADE_TRX, 4249917, Parent
6, TOTAL_DARTS, 4249917, Parent
1, TOTAL_DARTS, 4249917, Forex
2, TOTAL_DARTS, 4249917, Futures
6, EQUITY_TRADE_TRX, 4249917, Parent
1, FOREX_TRADE_TRX, 4249917, Forex
6, EQUITY_DARTS, 4249917, Parent
1, EQUITY_DARTS, 4249917, Forex
For TOTAL_DARTS if there is no record existing in the source for relationship_type_name FOREX , it should take the value from TRADE_TRX of relationship_type_name FOREX
For TOTAL_DARTS if there is no record existing in the source for relationship_type_name Futures , it should take the value from TRADE_TRX of relationship_type_name Futures
Similarly for EQUITY_DARTS if there is no record existing in the source for relationship_type_name Forex, it should take the value from FOREX_TRADE_TRX of relationship_type_name Forex
Telugu Jaathi Velugu Rekha!Telugu Talli Keerthipataaka!Telugu Atmagouravaprateeka!Nandamuri Tarakaramudu
|
|
Archives - 2011