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
- 6243 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / suraj kedia
The order of loading the schema is as below:
1)Dimension Table
2)fact table
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Enlist some properties of sessions.
explain abt ur project architecture?
What is exclusive and normal mode for repository services?
What are the different types of repositories created using informatica?
What is substr in informatica?
What is informatica?
what is song in infrmatica...?
Can we override a native sql query within informatica?
Explain what are the different versions of informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is a dimensional model?
What is a repository? And how to add it in an informatica client?
Explain direct and indirect flat file loading (source file type) - informatica
Clarify the utilization of aggregator cache record?
