Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
6 10038Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
TCS,
5 25317what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
3 11774in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
9 20527two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
TCS,
2 10249suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
TCS,
3 10673Post New Informatica Questions
r u done any partitions in ur project?
What is domain and gateway node?
Define pmcmd command?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Differentiate between source qualifier and filter transformation?
In informatica workflow manager, how many repositories can be created?
What is different between the data warehouse and data mart?
What are the components of the workflow manager?
How to load a Dimension ? and how to load a fact table?
How can we remove the duplicates from flat file source?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is workflow? What are the components of the workflow manager?
What is meant by a domain?
Repository user profiles
What will be the approach?