1)i put Pharma Project in my Resume..whar are the sources
used in my project Generally?
2)how many fact and dimensional tables used?
3)Have u used any Datamarts and measues in fact
table? ....plz give the answers...

Answers were Sorted based on User's Feedback



1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how man..

Answer / raam chowdary

i extract data from different sources like oracle,sap r/3,db2,flat files,terradata,mainframes..........
nearly 8fact tables
and 18dimension tables

Is This Answer Correct ?    1 Yes 0 No

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how man..

Answer / lokesh

only one fact table and Meany dimension tables
datamarts is subject oriented database

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Data Stage Interview Questions

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,


source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,


HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,


What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,


How can u write exception handling in seq file????

2 Answers   IBM,






If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,


1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


What are operators in datastage?

1 Answers  


Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,


What is staging variable?

0 Answers  


how many types of sorting the data in data stage?

1 Answers   BoA, IBM,


Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,


Categories