What is Assignment task in informatica? In what situation this task will be executed? Where this task exits?
Latest Answer: The Assignment task allows you to assign a value to a user-defined workflow variable. To use an Assignment task in the workflow, first create and add the Assignment task to the workflow. Then configure the Assignment task to assign values or expressions ...
Latest Answer: staging Area where we transform the source data into meaningful data ...
how to create parameter file and how to use it in a mapping explain with example
Latest Answer: Please place your parameter file in the server "srcfiles" with data in it.In mapping designer window of powercenter designer,click on "Mapping" and then "Parameter and variable".Add all the parameter here one by one.Now you ...
how does sorted input works in aggregator transformation
Latest Answer: Aggregator transformation performance can be improved by using the sorted input option. When you use sorted input, the PC Server assumes all data is sorted by group. As the PC Server reads rows for a group, it performs aggregate calculations. It ...
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: They are stored in xml ...
What are Meta Data Extenstions used in an informatica mapping? What is the significance,usage and how informatica handles them?
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
