shivaleela


{ City } banglore
< Country > india
* Profession * sse
User No # 9050
Total Questions Posted # 11
Total Answers Posted # 6

Total Answers Posted for My Questions # 57
Total Views for My Questions # 182987

Users Marked my Answers as Correct # 68
Users Marked my Answers as Wrong # 17
Questions / { shivaleela }
Questions Answers Category Views Company eMail

wht is degenerated dimension ?it's uses?

CTS, Infosys,

10 Data Warehouse General 48818

What is Molap and Rolap? What is Diff between Them?

 10 Data Warehouse General 17365

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

TCS, Wipro,

4 Informatica 13447

how do u use sequence created in oracle in informatica? Explain with an simple example

CTS,

6 Informatica 18187

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

CTS,

4 Informatica 9437

can v update d records in target using update stargey without generationg primary key ? explain

CTS,

4 Informatica 15395

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

Wipro,

1 Informatica 6683

hw cn v elimate dublicate values from lookup without overriding sql?

CTS,

7 Informatica 15600

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

TCS,

6 Oracle General 12176

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

 2 Informatica 7030

Can any one give the example for slicing and dicing of data ?(with simple query)

Cognos,

3 Cognos 18849



Answers / { shivaleela }

Question { Accenture, 47622 }

When should you use a STAR and when a SNOW-FLAKE schema?


Answer

STAR SCHEMA:-if PERFORMANCE is the priority than go for
star schema,since here dimension tables are DE-NORMALIZED

SNOW-FLAKE SCHEMA:-if MEMORY SPACE is the priority than go
for snoflake schema,since here dimension tables are
NORMALIZED

Is This Answer Correct ?    36 Yes 5 No

Question { 6650 }

WHAT IS CARTESIAN PRODUCT?


Answer

Cartesian product:- It is a type of join in which the
number of rows in the result table is the product of the
number of rows in each table.It is also called as CROSS JOIN

Eg:-

SELECT * FROM A,B

or (can be writen as)

SELECT * FROM A CROSS JOIN B


if A has 10 records n B has 8 records than the output of
above query will b 80 records(10*8=80 RECORDS).

Is This Answer Correct ?    5 Yes 1 No


Question { 28471 }

what is dimension table?


Answer

Dimensional Table:-It contains detailed information of one
Particular department

Eg:-Customer dimension it contains all the information
about the customer like name,place,DOB, city n so on along
with one primary key.

Is This Answer Correct ?    15 Yes 5 No

Question { Fidelity, 9592 }

what is difference between delete and truncet ?


Answer

DELETE:-

1.it is a DML stmt
2.it can include WHERE condition
3.it is only delete, so it can be rolled back can be ROLL
BACK

TRUNCATE:-

1.it is a DDL stmt
2.it can not include WHERE cnd
3.it is delete+commit ,so we cant roll back can not be ROLL
BACK


Both commands accomplish identical tasks (removing all data
from a table), but TRUNCATE is much faster

Reason:When you type DELETE.all the data get copied into
the Rollback Tablespace first.then delete operation get
performed.Thatswhy when you type ROLLBACK after deleting a
table ,you can get back the data(The system get it for you
from the Rollback Tablespace).All this process take
time.But when you type TRUNCATE,it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster.Once you Truncate you cann't get back
the data.


Is This Answer Correct ?    8 Yes 2 No

Question { Fidelity, 9592 }

what is difference between delete and truncet ?


Answer

DELETE:-

1.it is a DML stmt
2.it can include WHERE condition
3.it is only delete, so it can be rolled back can be ROLL
BACK

TRUNCATE:-

1.it is a DDL stmt
2.it can not include WHERE cnd
3.it is delete+commit ,so we cant roll back can not be ROLL
BACK


Both commands accomplish identical tasks (removing all data
from a table), but TRUNCATE is much faster

Reason:When you type DELETE.all the data get copied into
the Rollback Tablespace first.then delete operation get
performed.Thatswhy when you type ROLLBACK after deleting a
table ,you can get back the data(The system get it for you
from the Rollback Tablespace).All this process take
time.But when you type TRUNCATE,it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster.Once you Truncate you cann't get back
the data.


Is This Answer Correct ?    4 Yes 2 No

Question { Fidelity, 9592 }

what is difference between delete and truncet ?


Answer

DELETE:-

1.it is a DML stmt
2.it can include WHERE condition
3.it is only delete, so it can be rolled back can be ROLL
BACK

TRUNCATE:-

1.it is a DDL stmt
2.it can not include WHERE cnd
3.it is delete+commit ,so we cant roll back can not be ROLL
BACK


Both commands accomplish identical tasks (removing all data
from a table), but TRUNCATE is much faster

Reason:When you type DELETE.all the data get copied into
the Rollback Tablespace first.then delete operation get
performed.Thatswhy when you type ROLLBACK after deleting a
table ,you can get back the data(The system get it for you
from the Rollback Tablespace).All this process take
time.But when you type TRUNCATE,it removes data directly
without copying it into the Rollback Tablespace.Thatswhy
TRUNCATE is faster.Once you Truncate you cann't get back
the data.


Is This Answer Correct ?    0 Yes 2 No