Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project
Answer Posted / davankumar
Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is pmcmd command?
explain abt ur project architecture?
Explain pushdown optimization and types in informatica
What is a joiner transformation?
What is the maplet?
can we override a native sql query within informatica? How do we do it?
What is meant by a domain?
What is workflow? What are the components of workflow manager?
Enlist the various types of transformations.
How can we remove the duplicates from flat file source?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Write the unconnected lookup syntax?
Explain pmcmd command usage in informatica