Answer / d s r krishna

Parameter files are created with an extesion of .PRM

These are created to pass values those can be changed for
Mapping Parameter and Session Parameter during Mapping run.

Mapping Paramters:
A Parameter is defined in a parameter file for which a
Parameter is create already in the Mapping with Data Type ,
Precision and scale.

The Mapping parameter file syntax (xxxx.prm).
[FolderName.WF:WorkFlowName.ST:SessionName]
$$ParameterName1 =Value
$$ParameterName2 =Value

After that we have to select the properties Tab of Session
and Set Parameter file name including physical path of this
xxxx.prm file.

Session Parameters:

The Session Parameter file syntax (yyyy.prm).
[FolderName.SessionName]
$InputFileValue1=Path of the source Flat file

After that we have to select the properties Tab of Session
and Set Parameter file name including physical path of this
yyyy.prm file.

Do following changes in Mapping Tab of Source Qualifier's
Properties section
Attributes values

Source file Type ---------> Direct
Source File Directory --------> Empty
Source File Name --------> $InputFileValue1



Thanks

Answer / bhaskar

Parameter file is one which contains the values of mapping
variables.
type this in notepad.save it .
foldername.sessionname
$$inputvalue1=

in the session properties,under parameter file path specify
the path where this notepad is saved

Answer / rahul

parameter file ---- we have parameters and variable.

we can use than in mapping, session and work flow.

session: to change the cache path
workflow ; to know the status of prev tast.
mapping: to maintain constant value or to use last upadated
value

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

0 Answers   CTS,

---

what is scd?

6 Answers  

---

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

---

.prm wirh repalce .txt is possible?

2 Answers  

---

how to delete duplicate records by using filter transfermation?

3 Answers  

---

What are Business Components in Informatica?

1 Answers  

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

Differences between connected and unconnected lookup?

0 Answers  

---

In warehouses how many schemas are there?

0 Answers  

---

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

---

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---