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...
Answer Posted / 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 View All Answers
What is orabulk stage?
how to export or import the jobs in .ISX file
Differentiate between datastage and datastage tx?
Define orabulk and bcp stages?
Differentiate between data file and descriptor file?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the components of ascential data stage?
Explain connectivity between datastage with datasources?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Name the different sorting methods in datastage.
Can you explain link buffering?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are the areas of application?
What all are the different way to run a job?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?