1)i put Pharma Project in my Resume..whar are the sources used in my project G

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...

Question Posted / ping2babji

2 Answers
7913 Views
iGate, I also Faced
E-Mail 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 to find diff between 2 dates without using Icon... funtions?

1 Answers

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers TCS,

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers IBM,

what is a message handler

3 Answers IBM,

What is the difference between validate and compile?

1 Answers CTS,

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers TCS,

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers

Have you used Unstructured data?

0 Answers CTS,

Explain usage analysis in datastage?

0 Answers

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

0 Answers IBM,

For more Data Stage Interview Questions Click Here