Answer / vijaya

usually in almost all projects have customer dimension which
is fast growing dimension .

The fast changing dimensions which changes frequently.

Answer / venu

The Entities in the Dimention which are change rapidly is
called Rapidly(fastly) changing dimention. best example is
atm machine transactions

Answer / prince

Hi Venu, The definition you said for Fastly Changing Dimensions is true, but can you give one more example of a entity that changes frequently. Because ATM transactions will be loaded into FACT TABLE as that is a TRANSACTIONAL DATA but it is not loaded to DIMENSION TABLE.

Answer / janaki ram

Vijaya,

Is this right, i asked fastly changing dimension in DS

Answer / nagam

If a dimension table single attribute or multiple attributes are changing fastly based upon a time is called fast changing dimension table.

Ex:shareholders data in a business

Answer / alekhya

You can take 'age' of a customer as an example

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

what is snow flack schema?

2 Answers  

what is hash file

2 Answers   CTS, IBM,

What is the difference between the local container and shared container?

0 Answers  

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

Explain the importance of surrogate key in data warehousing?

0 Answers  

How To find the location of APT_confid file

2 Answers   CTS,

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

Explain connectivity between datastage with datasources?

0 Answers  

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,