What is parameter file?
Answers were Sorted based on User's Feedback
Answer / swetha
Parameter file is to define the values for parameters and
variables used in a session.A parameter file is a file
created by text editor such as word pad or notepad.
yoU can define the following values in parameter file
Maping variables
session parameters.
Is This Answer Correct ? | 1 Yes | 0 No |
Mapping Parameter is a constant value that can be defines in
before mapping run.
Mapping parameter file is created using Notepad or wordpad
with the extension of .txt or .prm.
If i wrong means mail to me chandranmca2007@gmail.com
Is This Answer Correct ? | 0 Yes | 0 No |
Explain the aggregator transformation?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
in oracle write query yourname+1 from dual
Global and Local shortcuts. Advantages.
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
Tell me about Propagate functions in informatica
What are the components of workflow manager?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,