Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mohini
the dimention table is connect to fact table.the splitted dimention tables are also connect the fact tables.the spiltted dimention tables also carries the same meaning across the total transaction.the dimention tables contains denormalized data.ths z called confirmed dimension.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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.
How would you copy the content of one repository to another repository?
Is it possible to revert a global repository to local one and why?
What is the fact table?
Can we create two repositories on same database instance in oracle?
what is INFORMATICA TESTING process
What is mapping debugger?
Explain scd type 3 through mapping.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to do the error handling of if ur source is flatfiles?
can you please explain me pre session and post session options?
What is the sql query overwrite in source qualifier in informatica
What is the function of union transformation?
How do you load first and last records into target table?
Tell me about MD5 functions in informatica
