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

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

---

explain abt joiner t/r?

1 Answers   IBM,

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

How we can confirm all mappings in the repository simultaneously?

1 Answers  

---

can you use flat file for repository?why?

2 Answers   TCS,

---