How do you load dimension data and fact data? Which is first
Answer Posted / usha
first we load data into dimension table then we will loadin
to fact table..
dimensions and facts has parent and child relationship.
many to one relation
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How do you import and export the datastage jobs?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the difference between informatica and datastage?
how to delete one row in target dataset
What are stage variables?
Can you explain engine tier in information server?
Does datastage support slowly changing dimensions ?
how to add a new records into source?
Explain how a source file is populated?
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
Explain usage analysis in datastage?
which r the connectors used in san?
How the ipc stage work?
Where do the datastage jobs get stored?
What are the repository tables in datastage?