how to create parameter file and how to use it in a mapping explain with example
Latest Answer: Suppose we have certain variable or parameter whoes value which change frequently so we will change that value in Parameter file( it is more feasible as no change in Mapping) ...
how does sorted input works in aggregator transformation
Latest Answer: Plus when Source data is data driven then Sorted won't effect Performance of aggregator ...
how can we display delimiters beside column names of target flat file?
Latest Answer: while creating the targets using flat files we will get a options to specify whether the flat file is delimited of fixed length following tht steps in one of the steps we get how to notify the delimiters in the flat file there we can adjust delimiters ...
Need to update the existing records,The record which is coming for update should be inserted and also the previous record's one column must be modified. i have used look up to look up the data.used
Latest Answer: Actually what need to be done here is:You need to use two update strategy transformation just before inserting or updating the data into target table, Obviously there will be two instances of target table one for each update strategy.Then use the property ...
what is the difference between a session and a task?
Latest Answer: Seesions : Set of instructions to run a mappingTask: session is type of task. other than that informatica several type of task like Assignment,Command,Control,Decision,Email,Event-Raise,Event-Wait,Timer,session ...
What is the practical use of a union transformation?
Latest Answer: That was the description....practical use would be like : if you have 3 different sources which returns different number of records but with the same ports and datatypes, union transformation can be used to sum up these records and proceed to the next ...
What is the file extension and format of the files for the Informatica objects like Mappings, sessions etc in the repository ?
Latest Answer: Repository is nothing but a database, rather a relational database, and in a relational database anything and everything is stored in tables. And tables are nothing but files with pointers. So in a repository these objects are stored in table, so they ...
What are Meta Data Extenstions used in an informatica mapping? What is the significance,usage and how informatica handles them?
In case of use of dynamic lookup cache in a lookup transformation, the lookup cache gets updated first and then the target table. What happens if the target table rejects a row after it is updated in the Cache?
Latest Answer: The Integration Service updates target tables based on key values. However, you can override the default UPDATE statement for each target in a mapping. You might want to update the target based on non-key columns.
When the Integration Service executes ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
