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
- 6336 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
Enlist the various types of transformations.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is an Integration service in Informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
How are the sources and targets definitions imported in informatica designer?
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
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to start a workflow using pmcmd command?
How to Create a folder using pmrep command?
Tell me about MD5 functions in informatica
where to store informatica rejected data?
Enlist the differences between database and data warehouse.
What is the Rank index port in Rank transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what are 3 tech challenges/ common issues you face?
