Oracle Interview Question Help Plz ..

[jaffanajeffada]

[quote name='google2011' timestamp='1335467066' post='1301692878']
emani explain chesavo kuda ekkada veyachu kada jaffa?
[/quote]

1. maintainance kashtam avutundhi
2. data redundant avutundhi
3. future columns add cheyyalsi vasthe table grain debbatintundhi
4. anni tables grain okala undadhu! data ni lowest grain lo maintain cheyyali etc etc

idhi oka 1 year back question! inka evevo cheppa! prastutham gurthu ille

[google2011]

[quote name='jaffanajeffada' timestamp='1335467109' post='1301692885']

appudu edhi use chesina okate... doesn't matter!!
[/quote]
avnaa.. emo nen adigina vallandaru unconnected antunaru kani reasons em cheppatleru ..

[quote name='jamajacha' timestamp='1335467263' post='1301692920']
data mart data partitioning..schemas adhi idhi ani...samepshi untaadu..
Normal forms all three types cheppi...performance wise describe chesindu emo..
[/quote]

heheehe ... jaffa ni adukoni untaru

[google2011]

@jafffa,
hehehe... inka informatica lo emaina gurtu unaya ??

[150bryant]

informatica tutorials emaina ivvandi please...

[150bryant]

[quote name='jaffanajeffada' timestamp='1335467386' post='1301692944']

1. maintainance kashtam avutundhi
2. data redundant avutundhi
3. future columns add cheyyalsi vasthe table grain debbatintundhi
4. anni tables grain okala undadhu! data ni lowest grain lo maintain cheyyali etc etc

idhi oka 1 year back question! inka evevo cheppa! prastutham gurthu ille
[/quote]
point noted officer

[google2011]

jamajacha, informatica tool install cheskoni unte .. help lo konni topics chadivite chalu ..

1. getting started
2. designer guide
3. transformation guide


ee 3 important..

[150bryant]

[quote name='google2011' timestamp='1335467754' post='1301693018']
jamajacha, informatica tool install cheskoni unte .. help lo konni topics chadivite chalu ..

1. getting started
2. designer guide
3. transformation guide


ee 3 important..
[/quote]
yeah tool undhi kaani...some times...connections chestuntey powermart lo avatledhu..
naku basic behind architecture telidhu kabatti..troubleshoot cheyalekapothuna..
anyways nuvu okasari eppdo share chesina Informatica pdf ni chaduvuthunaa...
kakapotey practice chestey better ani naa peeling..

videos, tutorials apart from help section..ekada chudaali ?

[jaffanajeffada]

[quote name='google2011' timestamp='1335467491' post='1301692964']
@jafffa,
hehehe... inka informatica lo emaina gurtu unaya ??
[/quote]

Informatica velocity says use less number of transformations to get the performance, but at the same time it also says the combination of sorter and aggregator(One extra transformation) gives performance boost!

how do you justify that??

[jaffanajeffada]

[quote name='google2011' timestamp='1335467428' post='1301692951']
avnaa.. emo nen adigina vallandaru unconnected antunaru kani reasons em cheppatleru ..
[/quote]

reason cheppakunda answer cheppodhu ani cheppu!!

[150bryant]

[quote name='jaffanajeffada' timestamp='1335468064' post='1301693081']
Informatica velocity says use less number of transformations to get the performance, but at the same time it also says the combination of sorter and aggregator(One extra transformation) gives performance boost!

how do you justify that??
[/quote]
using optimal number transformation with a combination of appropriate steps required for task to be done is the right thing to do

[google2011]

nen ento quote cheyalekapotuna...

@jamajacha... videos ante naku idea ledu ... may be youtube lo untayemo .. jaffa, ne dagara emaina unaya ??

@jaffa, ala pedha pedha questions adigite kashtam oy .. nuvve ans kuda cheppu

[jaffanajeffada]

[quote name='jamajacha' timestamp='1335467660' post='1301693000']
point noted officer
[/quote]
cheers bro

[jaffanajeffada]

[quote name='jamajacha' timestamp='1335468243' post='1301693110']
using optimal number transformation with a combination of appropriate steps required for task to be done is the right thing to do
[/quote]
in a way nuvvu cheppindhi correct ee bayya... but ala vaadithene endhuku performance boost vastundhi ani adigaadu!

[quote name='google2011' timestamp='1335468279' post='1301693119']
nen ento quote cheyalekapotuna...

@jamajacha... videos ante naku idea ledu ... may be youtube lo untayemo .. jaffa, ne dagara emaina unaya ??

@jaffa, ala pedha pedha questions adigite kashtam oy .. nuvve ans kuda cheppu
[/quote]

1. Sorter transformation in informatica uses an sorting algorithm that is developed by Syncsort application which is an efficient algorithm in sorting the data
2. When you give sorted data to aggregator, it will not build any cache for the aggregations and hence increases the performance

[150bryant]

[quote name='jaffanajeffada' timestamp='1335468580' post='1301693168']
in a way nuvvu cheppindhi correct ee bayya... but ala vaadithene endhuku performance boost vastundhi ani adigaadu!



1. Sorter transformation in informatica uses an sorting algorithm that is developed by Syncsort application which is an efficient algorithm in sorting the data
2. When you give sorted data to aggregator, it will not build any cache for the aggregations and hence increases the performance
[/quote]
gintha performance analysis..CompScience sadvithey ney seppagalam...

[pavan_613]

Ohh veeekuba