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 10046Generally 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 25322what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
3 11779in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
9 20533two 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 10253suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
TCS,
3 10677Post New Informatica Questions
What is dynamic cache?
What are the settings that you use to configure the joiner transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain the aggregator transformation?
What is the maplet?
What is native users?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
wat are deployement groups in informatica, how it will be used for developers
What is intricate mapping?
In informatics server which files are created during the session rums?
How an expression transformation differs from aggregator transformation?
What is a dimensional model?
Reusable transformation and shortcut differences
Mention few advantages of router transformation over filter transformation.
Is it possible to revert a global repository to local one and why?