Latest Answer: With the help of a source Qualifier and Lookup we can overide SQL Query. ...
Latest Answer: informatica power center 8.5 ...
Answer posted by Staline on 2005-05-27 00:42:44: You can use a Command task to call the shell scripts, in the following ways: 1. Standalone Command task. You can use a Command task anywhere in the
Latest Answer: Hi,There are two ways to do this,they are as follows:1)we can use a command task anywhere in the workflow or worklet to run the shell commands.2)In the session task,we can call reusable command task in the pre-session post_session property ...
Answered by kiran on 2005-05-08 09:20:30: Informatica Metadata contains all the information about the source tables, target tables, the transformations, so that it will be useful and easy to perform transformations
Latest Answer: All informations about the mappings,workflows such as Source,target,transformations are converted into metadata format and it is stored in the Repository database.The repository database is a open database,which can be accessible by the Repositoy server ...
Answered by kiran on 2005-05-08 09:32:14: An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and
Latest Answer: Active transformation is nothing but it will change the no of rows passing through it (example) Filter transformation .In it when we have 1000 rows as input after filter transformation according to the condition the output will be modifiedPassive ...
Latest Answer: In a warehouse I would recommend analyzing the data either after each load has completed, or periodically (week-end or month-end) depending upon the data volumes and therefore the effort required. You can analyze a table in Oracle at the Database, Schema ...
Latest Answer: Hi,We can extract SAP data by using informatica with the powerConnect option.We need to install and configure the powerConnect tool . Import the Source in to the Source Analyzer. Here PowerConnect is the gateway between SAP & Informatica.Then develop ...
Latest Answer: There are pros and cons of both tool based ETL and hand-coded ETL. Tool based ETL provides maintainability, ease of development and graphical view of the flow. It also reduces the learning curve on the team. Handcoded ETL is good when there is minimal ...
View page << Previous 2 3 4 5 [6]
Go Top
