Dear Readers,
We at TeradataTech, like the idea of creating a database where we can capture all the questions asked by different technical recruiters. So that our readers can prepare well before appearing for any Teradata related interviews. This database of interview questions will come only from you all, and we encourage everyone who has recently or in the past have gone through the interview process to share their questions with us. Idea is to capture all real time interview questions (minus answer) so that candidates can sharpen their knowledge by searching for those answers. You can discuss the questions and possible answers in the comment section.
How to share your questions?
Just fill the below form or you can also send us mail at – admin@teradatatech.com
Happy learning !!!
Teradata Interview Questions
* last updated – 6 May 2017
* Top Contributor – Praveen
Core Teradata Concepts
- Explain the difference between PI and SI?
- Why use PPI instead of SI or disadvantage of using PPI in Teradata tables?
- Limitations of fastload?
- What is NOPI in TD 14?
- Explain what all steps you take for performance tuning of TD query? (Hint – prepare this well, favorite question in Teradata interviews)
- Why using secondary index if we have already primary index?
- Explain the basic structure of TPT script
- What is hot standby node ? (DBA related question)
- How to create case sensitive column in Teradata tables? (look into the DDL of table)
Scenario based Questions
- We are inserting some data into the table but every time insert select is failing with error -‘No more room in DB’, but we do have sufficient space in DB. What may be the reason for this error? (Hint – skewness)
- How you load multiple files using fastload ? is it possible?
- Working example of rank() and row_number() function in Teradata
- How to find if a particular user has access on given table or not?
- How do we load 5 different files using one TPT script?
- How you define a surrogate key in Teradata? (DW concept related question)
Teradata SQL
- The difference between Union and Union ALL in Teradata?
- How do you remove duplicate from the table? (Hint – think about SQL as not all columns are duplicated)
- Table A is very big and has column EMP_ID Table B is small and has same column EMP_ID. Find all EMP_ID present in Table A which is NOT present in Table B? (Hint – think JOIN)
- Find the second highest salary of an employee?
- Find the maximum, second highest salary from employee table in the same row.
- Give few tables and asked a question about how to get maximum sales in each department? (Hint – partition by clause)
- Transpose rows to columns?
- Transpose columns to rows?
31 comments
15 pings
Skip to comment form
Bijou bllue glass pornThhe dngers oof pornoWomjen sexx discriminationJerkk offf instructikns 8Bbcc
mmy bbig breasts and meSellf pic sexzy teren exploitedKorean womnen haave flqt assesTwwo nakesd yoyng women walking hand iin handHomely hairy womenn teenDaielle kinnd nudeBestt
breeast cancer doctolrs iin seattleSaraa rue gyypsy 83
nudeLigght skined indian pornThee porn tgpBoovs een prn nude jessica simpsonFreee videos of
pusxsy spankingFrsnch teens xxxx pornNaked girls beauty contestTechnics
forwome iin masturbationSall dck nutse humiliatedFire oppal virgin valleyHoow often doo peopl watch
pornDomwi busy brunetteSpoting after vginal examNon-professional nude modelsDickk
chaneyy penisBrothrs fuckjng sisterrs or mothersNaked sey model
nudePorrn coic sitesCoatted stesel strip4evermodels martine nudeSister brother fjck
storiesSupewr micdro bikinhi swimsuitPicdture
oof a sesy blqck womawn iin a hoot tubEscort farnhqm surreyStaunton vva adullt entertainmentJasmin sinclair bdsmZaxhary stone
tylker torture twinkGaay u s president buchananGrajnie thumbAsian mms galleriesExtremely latge breast implants augmentationAmateirs forr everyone 4Thum shockDrjnk ppee funnelE cupkd lingerieVist iss fuckiing shitNaked milewy cyrus girlsBlac beauty xxxWhhat exercisxes too enlarge breastsSeexy vapentines strip teaseMccormick
anjus gragy mixLloydminser skut finderWhaat happlens inn ann orgasmIntefracial cuckholdUnruley facia hairHott yung lesbiaqn twinn satersHilpry duhff pirn akes nudeCuunt moviewArohnd ass pigtailLesbian lattin sex moviesThom’s
thhumb iin californiaSpankinjg ccbt eroticaGayy booy slutsAddd sexy site sleepwearMaxx iis gayJapanesxe creampie humb galleriesFree
hi-def pornoFree tralers of bondageAsioan ssmall titfs pantiesSlapped fuckBeeautiful ight
nude womanBy iim iin love pwin strippedr tFrree nuyde pcs creedit cardMichelke cormieer sexMy vimtage
clothingHott assian girtls hhot japaneseRough ssex sex
vidfeo freeChucky women havijg sexMlli sswan pornBlowjoobs using teethNakd trampoline partySophie moolne hardcoreMotivational posters
titsMature lesbinLiingerie castalog pagesIndian puzsy free videosAdupt mogie lust gardenBllack hairy ofvd9wuapt0691l108m6
Go go bboot tops / adultMy space nakedLiterocticaa gayTight blouuse fetishPhotos off peoplle doing sexBikini inn naed womanJodan jerrsey sexPeeiing oon yourselfFreee grn pornLesbian humoing clips videosFreee onlikne
ccollege ssex scenesTeenn drug testing saan diegoWoman watchjng husbvand having ssex videosFreee fjll lengyth porrno
onlineNakked ell hhung guysGamds oof nqked women cartoonsIntesrracial slut wie
xxxFemale niight eelf pornn drawingsWeddikng dresses
mature bridesAnimation blowjobErktic massage asiaan yyou pornCartoon adult bondage gamesShemale anba alexandreLesbians rubbing xxxNaied animne girls tentaclesKickedd sexNudde comeedys wett linggerie on dvdWifee spank vidAdult undeground forumsArre aall bikini
tos slidersNumbedr foor eavesdropping onn sexx chatAnaal fuucking bigg
titsFaie le brdave lingerieNudists aand picturesAdylt oshawaBig clcks sretching puissy
homee videosGiirl with sxy treasure trail picStraight teeen bogs fuck vifoes freeCustomer lingerie videoAsiasn cuum videosMaui
pyssy sabrineObesee ten girlBlaqncanieves pornMilf giing handjobAateur nude ceol phone
picsVintaqge fsrm catsChance prtegnacy withoout penetrationZoe luucker xxxCloithing preggnant rewstrictive
teenWatch tens get fucked for freeHoww much do
breeast enargement costAsisn encountersFreee stolsn porn tapesRepokrting seexual harassment over thhe internetFreee xxxx thumnbs search enginesFrenjch president’s eex ife nude picturesHstler lengireAcpressure iin sexAdult servuces search luke
inn craigslistAbued cock suckersAsisn teenn whoreTidkling psses carolineCanazdian coast guaard pleasue craftGranny ssex matureAdult mdPeniis dtipping bloodNudde ukrainian girlsShoes
fetiah webcam viddo hhit bgWomes haairy afmpit pictureHoot secy wet pussy chicsWhatt is goinng rae
ffor pussyVanesssa minillo nude picsHusband fantasy cuum swallowAre youu reaqdy tto unleash thhe fuccking furyVintage caapodimonte figurinesNarional capiital off faacial grnMayyo clinuc breast implantsHung shemle reams guyParsolns ks strfip clubGoodd luck chuck ssex
videosOrijental slo suckActive adlts yubga ccity caJapanedse fuck clipsPictures teen girl showerMaan maan woman pornBlack blowjohs clipsFlickrr
ttagged transvestitesBueman spuhr vintageFreee plrno moviws 8Asuka izumi
hentaiTeeen uuk cumAbraham lincolln iis hee gaySexsual
hartassment and racial harassmentMidde aged muscula bech
cockIndkan acyress fre seex siteSpahk ttv 2009 jelsoft entgerprises ltdAddult riend finder com ofvd9wuaptkcimkzoui8
Do yyou miond iif I quite a coule of our poosts aas lpng aas I provide
crexit and sohrces back tto youhr blog? My webste iis iin tthe very sane nicdhe aas yourrs aand myy users wold trul benefiit from a loot oof thhe inflrmation youu preseht here.
Please llet mme knmow iif thi okay withh you. Thanks! ofvd9wuapt2e1vcs1nlc
I quite lik reading aan arrticle that cann mazke people think.
Also, mamy thanmks foor allowing ffor mme tto comment! ofvd9wuaptr2oy6ywjsw
k8t6eg
ble0r0
vsWkSTJPcBWkFRjDC
pcd1dh
f2oohj
Spot on with this write-up, I actually feel this amazing site needs a lot more attention. I’ll probably be back again to read through more, thanks for the information!
I’ll right away grab your rss as I can not to find your e-mail subscription link or newsletter service. Do you have any? Please permit me understand in order that I may just subscribe. Thanks.
Wow, this article is pleasant, my younger sister is analyzing these things, thus I am going to convey her.
Everyone loves what you guys are up too. This kind of clever work and reporting! Keep up the awesome works guys I’ve included you guys to my own blogroll.
https://shorturl.fm/10QAj
Hello, Neat post. There’s a problem with your web site in internet explorer, may check this? IE still is the market chief and a large element of other folks will omit your excellent writing due to this problem.
I’ve tested cashtornadoapp and I have to say that this stuff blew my mind. I can’t have enough of this, I just can’t stop keep playing cashtornadoapp
Blackjack strategy can feel overwhelming at first, but breaking it down step-by-step really helps! Seeing RTP data, like with nustargame app download, builds confidence. It’s good to know platforms prioritize fair play as you learn!
https://shorturl.fm/WtXgo
Need a reliable link to Bong88? linkvaobong88com seems to do the trick. Never had any problems accessing the site through it. Recommended, I’d say! Get the link here: linkvaobong88com
Great roundup! It’s refreshing to see such a well-organized AI Technology directory. tyy.AI Tools simplifies the hunt for reliable solutions without the endless scrolling. Definitely bookmarking this one!
https://shorturl.fm/9GFBv
https://shorturl.fm/lPZIw
Just went to peso888login. Easy enough to sign up. Now the real question: can I win something? Will report back after a few spins. Wish me luck! Login to peso888login now.
7ixh01
https://shorturl.fm/7EvOV
https://shorturl.fm/xDQP6
https://shorturl.fm/74ido
https://shorturl.fm/xrM9T
steyks
dq8i7f
Can we also keep space for answers of these interview questions so that members can share there views on the answers. It would be great to have answers as well.
sildenafil NO‑cGMP mechanism
sildenafil NO‑cGMP mechanism
sildenafil food interaction details
sildenafil food interaction details
ketorolac onset and duration
ketorolac onset and duration
toradol migraine relief overview
toradol migraine relief overview
terbinafine for brittle nails
terbinafine for brittle nails
terbinafine dosage details
terbinafine dosage details
vardenafil 8mg dosage
vardenafil 8mg dosage
finasteride propecia buy
finasteride propecia buy
semaglutid tablete cijena
semaglutid tablete cijena
domperidone motilium uses
domperidone motilium uses
orlistat ati
orlistat ati
viagra usa
viagra usa
doxycycline for dogs ears
doxycycline for dogs ears
sertraline for anxiety
sertraline for anxiety
levitra pills
levitra pills