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
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 |
Answer / lokesh
only one fact table and Meany dimension tables
datamarts is subject oriented database
Is This Answer Correct ? | 0 Yes | 2 No |
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?
source file is having 5 records while moving into target it want to be 10 records
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
What is the function in Transformer stage can act as Rank Function in oracle
How can u write exception handling in seq file????
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
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?
What are operators in datastage?
Display all files which have size more 3KB in given directory/folder.
What is staging variable?
how many types of sorting the data in data stage?
Tell me Wt main advantage of Stage varibles? Project level hints?