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
Describe stream connector?
What is oci?
On which interface you will be working as a developer?
how to export or import the jobs in .ISX file
What are the some differences between 7.x and 8.x version of datastage?
How can you write parallel routines in datastage PX?
Why we use surrogate key?
What is job control?
Differentiate between datastage and datastage tx?
What is the difference between orabulk and bcp stages?
What is the difference between passive stage and active stage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How the ipc stage work?
in oracle target stage when we use load option and when we use upsert option?