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

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

How do you load dimension data and fact data? Which is first

2 Answers  

Explain briefly scd type2 in datastage7.5x2(parallel)

1 Answers   IBM,

How to display errors in datastage?

1 Answers   TCS,

how to delete one row in target dataset

0 Answers   Satyam,

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

What are the primary usages of datastage tool?

0 Answers  

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

Explain ibm infosphere information server and highlight its main features?

0 Answers  

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

0 Answers   UHG,

In merge stage can we update the values?

3 Answers   TCS,