sreeku_2035 Posted April 18, 2012 Report Posted April 18, 2012 [quote name='Silver_mani' timestamp='1334712475' post='1301653074'] cool baa .... so adi [color=#282828][font=helvetica, arial, sans-serif]lookups and non Lookups ni seperate chestundi kada [/font][/color] [/quote] Non look ups ante unmatched records aa baa? if yes my way is correct
RHUSTUM Posted April 18, 2012 Report Posted April 18, 2012 [quote name='Silver_mani' timestamp='1334712475' post='1301653074'] cool baa .... so adi [color=#282828][font=helvetica, arial, sans-serif]lookups and non Lookups ni seperate chestundi kada [/font][/color] [/quote] lookup lo drop option petti reject link pettu..match ayina records target ku potai...non lookup data rejects ku pothadhi.......
D.V.S.KARNA Posted April 18, 2012 Report Posted April 18, 2012 [quote name='shivudu' timestamp='1334712943' post='1301653096'] lookup lo drop option petti reject link pettu..match ayina records target ku potai...non lookup data rejects ku pothadhi....... [/quote]
Silver_mani Posted April 18, 2012 Report Posted April 18, 2012 [quote name='sreeku_2035' timestamp='1334712942' post='1301653095'] Non look ups ante unmatched records aa baa? if yes my way is correct [/quote] avunu baa Unmatched records ... nenu ade chesina ... transformer petti Unmatched records ki vere lookup petti .... last anni results ni funnel chesa ...it works .....kani help lo chusina baa ... column add chesi kuda seperate cheuuochu anta ... adi artham kale anduke post vesina
Silver_mani Posted April 18, 2012 Report Posted April 18, 2012 [quote name='shivudu' timestamp='1334712943' post='1301653096'] lookup lo drop option petti reject link pettu..match ayina records target ku potai...non lookup data rejects ku pothadhi....... [/quote] bussiness req adi kadu le mama ... rejects kuda target ki povali ( I mean next stage ki )
D.V.S.KARNA Posted April 18, 2012 Report Posted April 18, 2012 [quote name='Silver_mani' timestamp='1334713188' post='1301653109'] bussiness req adi kadu le mama ... rejects kuda target ki povali ( I mean next stage ki ) [/quote] ohh..ok
Silver_mani Posted April 18, 2012 Report Posted April 18, 2012 [quote name='sreeku_2035' timestamp='1334713218' post='1301653110'] Cool baa enjoy [/quote] adi kadu mama .... column add chesi edo cheyyochu anta ( even without using transformer ) ... adi telusa ?
maserati Posted April 18, 2012 Report Posted April 18, 2012 bayya memu aite ila chestam 1 as RecordFound (ane column ni add chesi) integer(data type) 4(size) Yes(Nullability) ani data base columns and query lo add chesi send it to transformer and then use constraint as IsNotNull(RecordFound) appudu onlu match columns vastayi
sreeku_2035 Posted April 18, 2012 Report Posted April 18, 2012 [quote name='Silver_mani' timestamp='1334713490' post='1301653124'] adi kadu mama .... column add chesi edo cheyyochu anta ( even without using transformer ) ... adi telusa ? [/quote] No Idea baaa .
Silver_mani Posted April 18, 2012 Report Posted April 18, 2012 [quote name='sreeku_2035' timestamp='1334716289' post='1301653225'] No Idea baaa . [/quote] NO problem mama ... ee thread ki regular ga vasta vundu mama [img]http://lh4.ggpht.com/_KUBIxHQtVVY/S8B3H7WgS2I/AAAAAAAAB5I/35Nh1_ShAF0/s400/brahmam_style1.png[/img]
qwerty1204 Posted April 18, 2012 Author Report Posted April 18, 2012 [quote name='sreeku_2035' timestamp='1334712942' post='1301653095'] Non look ups ante unmatched records aa baa? if yes my way is correct [/quote] baa...lookup lo oka row match avvaledu ante..it doesn't need to bee null kadaa...may be data doesn't match anee case kuda untayi kada....so nxt step loo transformer loo null..and not null tho manmu filter cheyalemu anukunta baa....and correct way lo ela cheyalii antee naaku no idea baa
Silver_mani Posted April 18, 2012 Report Posted April 18, 2012 [quote name='arey ooo samba' timestamp='1334717926' post='1301653360'] baa...lookup lo oka row match avvaledu ante..it doesn't need to bee null kadaa...may be data doesn't match anee case kuda untayi kada....so nxt step loo transformer loo null..and not null tho manmu filter cheyalemu anukunta baa....and correct way lo ela cheyalii antee naaku no idea baa [/quote] Match aithe aa row vastadi ... Match kaka pothe null(if nullable) or 0 (if not null) baa [img]http://lh4.ggpht.com/_KUBIxHQtVVY/S8B3H7WgS2I/AAAAAAAAB5I/35Nh1_ShAF0/s400/brahmam_style1.png[/img]
qwerty1204 Posted April 18, 2012 Author Report Posted April 18, 2012 [quote name='Silver_mani' timestamp='1334718489' post='1301653407'] Match aithe aa row vastadi ... Match kaka pothe null(if nullable) or 0 (if not null) baa [img]http://lh4.ggpht.com/_KUBIxHQtVVY/S8B3H7WgS2I/AAAAAAAAB5I/35Nh1_ShAF0/s400/brahmam_style1.png[/img] [/quote] for example table1 data ila undi baa col1 col2 col3 1 abc xyz table 2 data ila undi col1 col4 col5 2 mnc pqr lookup stage loo col1(table1)=col1(table2) ani ichi..lookup condition continue ani pedithe output ila vsthundaa aa baa (output file lo ki manamu col2 col3 col4 col5 map chesamu anukoo) col2 col3 col4 col5 abc xyz NULL NULL is that right?
Silver_mani Posted April 18, 2012 Report Posted April 18, 2012 [quote name='arey ooo samba' timestamp='1334719675' post='1301653463'] for example table1 data ila undi baa col1 col2 col3 1 abc xyz table 2 data ila undi col1 col4 col5 2 mnc pqr lookup stage loo col1(table1)=col1(table2) ani ichi..lookup condition continue ani pedithe output ila vsthundaa aa baa (output file lo ki manamu col2 col3 col4 col5 map chesamu anukoo) col2 col3 col4 col5 abc xyz NULL NULL is that right? [/quote] ila vastundi mama output col1 col2 col3 col4 col5 1 abc xyz Null Null Null
Recommended Posts