kalpana


{ City } bangalore
< Country > india
* Profession * sap bi consultant
User No # 84237
Total Questions Posted # 0
Total Answers Posted # 8

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 105
Users Marked my Answers as Wrong # 25
Questions / { kalpana }
Questions Answers Category Views Company eMail




Answers / { kalpana }

Question { Wipro, 9049 }

what methodologies you are following


Answer

Agile methodology...sprint plans,scrum meetings

Is This Answer Correct ?    0 Yes 0 No

Question { 12667 }

what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?


Answer

Some times the primary constraint may violate at that time
we go for surrogate key.

Is This Answer Correct ?    2 Yes 1 No


Question { 12667 }

what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?


Answer

the above one is primary key constraint

Is This Answer Correct ?    1 Yes 1 No

Question { 4787 }

what are cost based and rule based approaches and what is
the difference?


Answer

costbased and rule based approaches r used as optimization
techniques in improving the performance of queries

Is This Answer Correct ?    1 Yes 0 No

Question { TCS, 15499 }

what is the difference between stop and abort?


Answer

stop is a command used to stop a session or a batch
abort is similar to stop except it has a 60 second timed out

Is This Answer Correct ?    10 Yes 2 No

Question { CTS, 91990 }

What is a diff between joiner and lookup transformation


Answer

joiner doesnt support nonequi joins where as lookup support
nonequijoin

Is This Answer Correct ?    72 Yes 12 No

Question { NIIT, 8943 }

difference between oracle8i and oracle9i


Answer

merge is a command which is used to both insert and delete.
timestamp datatype is introduced.
max no of columns in 8i is 256 where as in 9i we can have
999.
on delete set null supports only in 9i.
by using this, when we delete the parent record the child
records are replaced with null values

Is This Answer Correct ?    11 Yes 7 No

Question { 9553 }

wt is inline view? when and why we Use ?mail to
rayallarv@gmail.com


Answer

Inline view is a construct in oracle.Inline views allow us
to do things in a single query that might otherwise require
multiple sql statements.

A common use for inline views is to simplify complex
queries by removing join operations and condensing several
separate queries into a single query.

Is This Answer Correct ?    8 Yes 2 No