In your mapping using sequence generator transformation, the limitation of the transformation is it generates key values only around 2 million. If it is more than 3 million records are there in your source, how will you generate key values and load into target.
Latest Answer: 10GB ...
Latest Answer: Instead of creating multiple cache files informatica server creates only one cache file for all the lookups used with in the mapping which selected as a shared cache option. ...
Latest Answer: Using Normalizer, in the normalizer properties we can add coloumns and for a coloumn we can specify the occurance levels, which converts rows into coloumns. ...
What is granularity in INFORMATICA? How should be the level of granularity for a fact table as well as for a dimension table?
Latest Answer: Data Cleansing Tool: TriliumProfile tool: Informatica Profiler ...
Latest Answer: User Normalizer. This transformation used to normalize data. ...
Latest Answer: Unless the job is scheduled, you cannot manually run a workflow without using a GUI. ...
What is the difference between Enterprise data warehouse and a data warehouse ??Which all transformation uses the cache directory ?
ex-: Suppose a table EMP is in MAINFRAME then how can we access this table as SOURCE TABLE in informatica?
Latest Answer: Use the Normalizer transformation to take the Mainframe sources(COBOL) ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
