Jump to content

Hey SSIS medha evaraina work chesthunnara...need some help plzzz

manoghna

By manoghna
in Old Discussions

 Share

Recommended Posts

nenuinthe LEGEND

nenuinthe

Posted
Posted

[quote author=chelsea link=topic=152970.msg1793497#msg1793497 date=1297127027]
thankyou thankyou ba  you rock you rock
[/quote]np  sHa_high5ing sHa_high5ing...emana ssis mida doubts unte PM kottu rakapothe nenu nerchukunta  sSa_j@il sSa_j@il[quote author=manoghna link=topic=152970.msg1793508#msg1793508 date=1297127119]
thankyou thankyou so much  ........ it will be very useful to me... dentlo column update ithe mi table lo na?
[/quote]yup table

for example mana table lo already ila undi anukunam...

PID          PNAME      Date
1            ABC            7/1/2011
2            XYZ              7/2/2010

For example ivvale vache file lo undi anukunam

PID          PNAME      Date
1            ABC            8/1/2011
2            XYZ              7/2/2010
3          VGH                8/10/2007

anukunam so manam lookup use chesi 1st PID update ayyindi ani telusukunam 3rd PID New ani telusukunam
so 1st PID just update chestam OLED Command use chesi ...New Record 3rd  Inser chestam destination lo....so lookup vall niku kottavi entivo pativo entivo telusukovachu.....

  • Replies 90
  • Created
  • Last Reply

Top Posters In This Topic

  • manoghna

    22

  • nenuinthe

    21

  • chelsea

    15

  • polikeka

    6

Popular Days

Top Posters In This Topic

Popular Days

manoghna Sr. Hero

manoghna

Posted
  • Author
Posted

[quote author=chelsea link=topic=152970.msg1793392#msg1793392 date=1297126163]
ante Data migration from sql 2000 to 2005 ela cheyyali ba  real time lo ekkavya vache scenario cheppu ba.....
[/quote]oh miru kooda SSIS medha searching a job

nenuinthe LEGEND

nenuinthe

Posted
Posted

[quote author=Discussion link=topic=152970.msg1793511#msg1793511 date=1297127177]
lekapote edo pareesha rasinattu raasindu [img]http://s264.photobucket.com/albums/ii178/tejaprince/king/th_4watnonsense.gif[/img]
[/quote]andaru me anta talent kadu kada BODI....[img width=150 height=103]http://www.desigifs.com/sites/default/files/brahmam_style17_0.gif?1290369245[/img]

chelsea Sr. Hero

chelsea

Posted
Posted

[quote author=manoghna link=topic=152970.msg1793546#msg1793546 date=1297127487]
oh miru kooda SSIS medha searching a job
[/quote]
yeah i am also looking  for job in ssis  sHa_high5ing

polikeka Celebrity

polikeka

Posted
Posted

[quote author=BEZAWADA ROWDY link=topic=152970.msg1793550#msg1793550 date=1297127533]
andaru me anta talent kadu kada BODI....[img]http://www.desigifs.com/sites/default/files/brahmam_style17_0.gif?1290369245[/img]
[/quote]

[img width=250 height=107]http://i264.photobucket.com/albums/ii178/tejaprince/king/20norumuyi.gif[/img]

nenuinthe LEGEND

nenuinthe

Posted
Posted

[quote author=Discussion link=topic=152970.msg1793578#msg1793578 date=1297127743]
[img]http://i264.photobucket.com/albums/ii178/tejaprince/king/20norumuyi.gif[/img]
[/quote][img width=180 height=88]http://www.desigifs.com/sites/default/files/i65862_suman2.gif?1290262865[/img]

manoghna Sr. Hero

manoghna

Posted
  • Author
Posted

[quote author=BEZAWADA ROWDY link=topic=152970.msg1793540#msg1793540 date=1297127444]
np  sHa_high5ing sHa_high5ing...emana ssis mida doubts unte PM kottu rakapothe nenu nerchukunta  sSa_j@il sSa_j@ilyup table

for example mana table lo already ila undi anukunam...

PID          PNAME      Date
1            ABC            7/1/2011
2            XYZ              7/2/2010

For example ivvale vache file lo undi anukunam

PID          PNAME      Date
1            ABC            8/1/2011
2            XYZ              7/2/2010
3          VGH                8/10/2007

anukunam so manam lookup use chesi 1st PID update ayyindi ani telusukunam 3rd PID New ani telusukunam
so 1st PID just update chestam OLED Command use chesi ...New Record 3rd  Inser chestam destination lo....so lookup vall niku kottavi entivo pativo entivo telusukovachu.....
[/quote]ok so manam job schedule create chesthe xl file lo data first raw table lo update avuthundhi... lookup trasformation use cheyatam vala a newly updated row ento telusukovachu...so that a row ni fact table lo insert chestham ..correct yena nenu ardham chesukundhi..

chelsea Sr. Hero

chelsea

Posted
Posted

[quote author=BEZAWADA ROWDY link=topic=152970.msg1793540#msg1793540 date=1297127444]
np  sHa_high5ing sHa_high5ing...emana ssis mida doubts unte PM kottu rakapothe nenu nerchukunta  sSa_j@il sSa_j@ilyup table

for example mana table lo already ila undi anukunam...

PID          PNAME      Date
1            ABC            7/1/2011
2            XYZ              7/2/2010

For example ivvale vache file lo undi anukunam

PID          PNAME      Date
1            ABC            8/1/2011
2            XYZ              7/2/2010
3          VGH                8/10/2007

anukunam so manam lookup use chesi 1st PID update ayyindi ani telusukunam 3rd PID New ani telusukunam
so 1st PID just update chestam OLED Command use chesi ...New Record 3rd  Inser chestam destination lo....so lookup vall niku kottavi entivo pativo entivo telusukovachu.....
[/quote]

ba i think its like incremental loading la vunnadi like sending the data from ODS to DW we have insert new records and update changes made in the old records anthe na  sCo_hmmthink sCo_hmmthink

manoghna Sr. Hero

manoghna

Posted
  • Author
Posted

[quote author=nastyguys link=topic=152970.msg1793529#msg1793529 date=1297127340]
nenu SQL kadu .... kani maaa [b]buddodu[/b] ki baga vachu ...  sHa_high5ing sHa_high5ing
[/quote]hmm no problem....is it bezawadarowdy a buddodu ante?

polikeka Celebrity

polikeka

Posted
Posted

[quote author=BEZAWADA ROWDY link=topic=152970.msg1793584#msg1793584 date=1297127826]
[img]http://www.desigifs.com/sites/default/files/i65862_suman2.gif?1290262865[/img]
[/quote]

[img width=300 height=128]http://i264.photobucket.com/albums/ii178/tejaprince/king/belluehh.gif[/img]

chelsea Sr. Hero

chelsea

Posted
Posted

[quote author=Discussion link=topic=152970.msg1793578#msg1793578 date=1297127743]
[img]http://i264.photobucket.com/albums/ii178/tejaprince/king/20norumuyi.gif[/img]
[/quote]
poli ba how r u  sHa_fr1ends

manoghna Sr. Hero

manoghna

Posted
  • Author
Posted

[quote author=chelsea link=topic=152970.msg1793538#msg1793538 date=1297127432]
@gr33d hi how r  u  meru koda  sql BI job try chesthunara  sHa_high5ing
[/quote]am doing good..how ru?
sql developer with ssrs and ssis ...

nenuinthe LEGEND

nenuinthe

Posted
Posted

[quote author=manoghna link=topic=152970.msg1793590#msg1793590 date=1297127848]
ok so manam job schedule create chesthe xl file lo data first raw table lo update avuthundhi... lookup trasformation use cheyatam vala a newly updated row ento telusukovachu...so that a row ni fact table lo insert chestham ..correct yena nenu ardham chesukundhi..
[/quote][quote author=chelsea link=topic=152970.msg1793598#msg1793598 date=1297127873]
ba i think its like incremental loading la vunnadi like sending the data from ODS to DW we have insert new records and update changes made in the old records anthe na  sCo_hmmthink sCo_hmmthink
[/quote]yup miru anukunedi crrct e.....avi load cheyyalante job e schedule cheyyakarledu.......mamuluga kuda run chesina avutayi....teliste ok... sHa_high5ing sHa_high5ing

polikeka Celebrity

polikeka

Posted
Posted

[quote author=chelsea link=topic=152970.msg1793619#msg1793619 date=1297128012]
poli ba how r u  sHa_fr1ends
[/quote]

5n mama..how u  sHa_fr1ends

nenuinthe LEGEND

nenuinthe

Posted
Posted

[quote author=Discussion link=topic=152970.msg1793607#msg1793607 date=1297127946]
[img]http://i264.photobucket.com/albums/ii178/tejaprince/king/belluehh.gif[/img]
[/quote][img width=100 height=80]http://www.desigifs.com/sites/default/files/brahmam_style10r.gif?1290348785[/img]

 Share
Go to topic listing
×
×
  • Create New...