naresh


{ City } hyd
< Country > india
* Profession * software engineer
User No # 62238
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 # 52
Users Marked my Answers as Wrong # 31
Questions / { naresh }
Questions Answers Category Views Company eMail




Answers / { naresh }

Question { Symphony, 79001 }

What is an index and types of indexes. How many number of
indexes can be used per table ?


Answer

index's are used to retrive the data with in the required
time.there are two types of indexes we have

1.bitmap index
2.B-tree index

Is This Answer Correct ?    16 Yes 17 No

Question { 9933 }

what is meta data? Explain? Where it is used?


Answer

Metadata is nothing but data about data .It consists column
name, datatype ,size,precision,scale,constraints if any...

Is This Answer Correct ?    0 Yes 0 No


Question { IBM, 37463 }

if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs...srinu.thadi


Answer

Requirement is not clear ..can u please elaborate the
question(about metadata)

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 29027 }

what is sparse lookup?


Answer

Sparce Lookup : if u use normal lookup it takes the entire
table into memory and perform lookup..coming to sparce
lookup it directly perform the lookup in database level.

one more difference is we can update the data into reference
tables.

Is This Answer Correct ?    12 Yes 0 No

Question { 12499 }

table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?


Answer

IF the metadata is same then we can do this by using funnel
stage.
If the metadata is dirrerent then we can do this by using
join,lookup,merge stages

Is This Answer Correct ?    3 Yes 8 No

Question { 9550 }

HOW CAN WE SEE THE DATA IN DATASET?


Answer

We can see some sample data by using dataset stage itself

Is This Answer Correct ?    0 Yes 0 No

Question { IBM, 66187 }

What is the Difference Between DataStage 7.5 version and 8.1
Version?


Answer

The main functionality is the same ..but some new features
are added in 8.0.

1)data connection object
2)Range lookup
3)SCD stage
4)Advanced search
etc...

Is This Answer Correct ?    19 Yes 4 No

Question { 25359 }

how can u handle null values in transformer stage.


Answer

Depending on the client requirement we can handle the nulls
by using null handling functions..we need to handle nulls if
the column null type is no only ..

Is This Answer Correct ?    2 Yes 2 No