@@@@calling All Datastage Developers@@@@

[sreeku_2035]

[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]

[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]

[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]

[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]

[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 )

[sreeku_2035]

Cool baa enjoy

[D.V.S.KARNA]

[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]

[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]

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]

[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]

[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]

[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]

[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]

[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]

[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