Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinu
one fact table is surrounded by different dimension table
and dimension table relation with master dimension table is
called snowflake schema (or) extended star schema
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What are data elements?
what is ds administrator used for?
What is usage analysis in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Define repository tables in datastage?
Terminate Activity
If you want to use a same piece of code in different jobs, how will you achieve this?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
which r the connectors used in san?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to find value from a column in a dataset?
what are the devoleper roles in real time? plz tell i am new to datastage....
in oracle target stage when we use load option and when we use upsert option?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
