E T L Testing Interview Questions---Help

[150bryant]

[quote name='cherlapalli_jailer' timestamp='1372874999' post='1303916424']

select "fields" from tbl group by fileds having count > 1

then delete anthe gada ..what is other way?
[/quote]
select distinct (ids) from table
will do as well

[cherlapalli_jailer]

[quote name='BathiBottleBisket' timestamp='1372875131' post='1303916444']
select distinct (ids) from table
will do as well
[/quote]

id
1
1
2
3
4
4
4


then we 1,2,3,4

even single record also will come right? we cannot eliminate based on it

[150bryant]

[quote name='cherlapalli_jailer' timestamp='1372875293' post='1303916458']
id
1
1
2
3
4
4
4


then we 1,2,3,4

even single record also will come right? we cannot eliminate based on it
[/quote]
question is abt how to eliminate duplicates for tht column..
dont think abt the data associated with it..
if you are pulling data associated with it...then there will be more filter conditions to make things unique

[Anta Assamey]

Asalu E T L ante enti...

[tom bhayya]

[quote name='Brahmanandam_AFDB' timestamp='1372875712' post='1303916504']
Asalu E T L ante enti...
[/quote]

[cherlapalli_jailer]

[quote name='BathiBottleBisket' timestamp='1372875683' post='1303916498']
question is abt how to eliminate duplicates for tht column..
dont think abt the data associated with it..
if you are pulling data associated with it...then there will be more filter conditions to make things unique
[/quote]
k

thank you

more questions pl

[Anta Assamey]

[quote name='Alexander' timestamp='1372875821' post='1303916529']

[/quote]


Naa knowledge ki question valid ee kada....[img]http://i47.tinypic.com/4s086h.gif[/img]

[cherlapalli_jailer]

ltt

[cherlapalli_jailer]

LTT for more questions [img]http://i47.tinypic.com/4s086h.gif[/img]

[ICANWIN]

[quote name='Brahmanandam_AFDB' timestamp='1372875712' post='1303916504']
Asalu E T L ante enti...
[/quote]


Extract Transform Load..

[superhit]

LTT ...

[Anta Assamey]

[quote name='ICANWIN' timestamp='1373050598' post='1303922938']


Extract Transform Load..
[/quote]

Neeku okkadike ardam ayyindi.... naaku nijamgane adhi ento teliyadu ani...[color=#282828][font=helvetica, arial, sans-serif][img]http://i47.tinypic.com/4s086h.gif[/img][/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]

[ronitreddy]

ETL concepts adgutharu..

[ICANWIN]

[quote name='Brahmanandam_AFDB' timestamp='1373053528' post='1303923144']
Neeku okkadike ardam ayyindi.... naaku nijamgane adhi ento teliyadu ani...[color=#282828][font=helvetica, arial, sans-serif][img]http://i47.tinypic.com/4s086h.gif[/img][/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]
[/quote]


serious oo sarcasm oo teledu kani bro enno full forms telekunda enno vatini manam vadutune untam alane adigav anukunna...no offence

[Anta Assamey]

[quote name='ICANWIN' timestamp='1373054516' post='1303923193']
serious oo sarcasm oo teledu kani bro enno full forms telekunda enno vatini manam vadutune untam alane adigav anukunna...no offence
[/quote]


NIjam ga ne cheppanu.... Naaku teliyadu.. Nenu Biotec background so eppudu vinanu kuda vinaledu... [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)][img]http://i47.tinypic.com/4s086h.gif[/img][/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)] [/background][/size][/font][/color]