What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica.
Latest Answer: You can load the dimension table directly, but you cannot load the fact table directly, You need to look up the dimension table, b'coz fact tables contains foreign keys, which are the primary keys in dimension table. You can load the dimensions and facts ...
Latest Answer: Making use of Informatica PowerConnect for IBM MQ series. ...
Hi, I have an application with integrated COM object. Need to extract some columns of data from that application. Can I use external procedure transformation and try to extract this data directly into
Latest Answer: Yes. Using external procedure transformation. ...
Hi, Every thing is fine .But my problem is in work flow monitor the server will be disconnected.Even thought both oracle and informatica are running
Latest Answer: First you click my computer properties In the properties you click the computer name tab. IN the computer name tab you see the Full computer name that is your server name you should give that name (server name)in theserver configuration(Wrokflow manager) ...
I need to comment the stored procedure in the mapping
I am using Informatica 7.1.1, How to delete the existing repository, mappings?
Latest Answer: To delete repository- Delete it from Informatica Server Administrative ConsoleTo delete Mapping - Delete it from designer.To delete folder - Delete it from Repository Manager. ...
Latest Answer: Suppose we have choose 10000 source to be commitSource based Commitment is it will read 10000 rows and pass through many transformation (active and passive) so upto what out of 10000 rows it reaches the target it will commit And if we have 10000 target ...
Is it possible to have VSAM file as target? If yes can you suggest me how this can be done?
Latest Answer: I believe (although not 100% sure) that this is possible. Several years back in one of the projects we had used a tool called STRIVA which could directly read/write in the form of VSAM files. Lately Informatica bought the STRIVA tool and added in the ...
What is the difference between using a cached lookup and an uncached lookup?
Latest Answer: In Cache Lookup a cache will be created of that Lookup table and IS query once for mapping rows for Uncache lookup No cache will be build and IS query for each Mapping rows.So for performance Go for Cache lookup if Lookup table size< Mapping rowsGo ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
