Interested to Buy Any Domain ? << Click Here >> for more details...
how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
- 2 Answers
- 6366 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / sree
dimension tables are loaded first and fact tables.As all primary keys of the dimension table is linked with the foreign keys of fact table for proper lookup we need to load dimension tables first.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the different versions of informatica?
what is the Default Source Option For Update Strategy Transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the command used to run a batch?
What do think which one is the better joiner or look up?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What do you mean by blocking transformation?
Write the advantages of partitioning a session?
How to implement security measures using repository manager?
What is aggregator transformation in informatica?
What are the performance considerations when working with aggregator transformation?
What is the sequence generator transformation in informatica?
What are the modules in Power Center
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
