Q1>How do u change parameter when u move it from development to production.
Ans :: We can manually move the parameter file and save in prod server. (Posted :: Vijay )

Q2>How do u retain variable value when u move it from development to production.
Ans :: while moving the variables to prod make sure that you assign the default value while creating the variables in dev environment.when the code was moved it will check the repository and see if there is any value for that variable if there is no value then it takes the default value. (Posted :: Vijay )

Q3>How do u reset sequence generator value u move it from development to production
Ans :: Keep the sequence value as 1 in dev and move the code to prod. (Posted :: Vijay )

Q4>How to delete duplicate values from UNIX.
Ans :: UNIQ <filename>

Q5>How to find no.of rows commited to the target, when a session fails.
Ans :: Log file

Q6>How to remove the duplicate records from flat file (other than using sorter trans. and mapping variables)
Ans :: (i)Dynamic Lookup (ii) sorter and aggregator

Q7>How to generate sequence of values in which target has more than 2billion records.(with sequence generator we can generate upto 2 billion values only)
Ans :: Create a Stored Procedure in database level and call it using storedprocedure transformation.

Q8>I have to generate a target field in Informatica which doesn exist in the source table. It is the batch number. There are 1000 rows altogether. The first 100 rows should have the same batch number 100 and the next 100 would have the batch numbe 101 and so on. How can we do using informatica?
Ans :: develop a mapping flow

Source > sorter > sequencegenerator (generate numbers)> expression (batchnumber , decode function) > target

Expression :: decode(nexval<=100, nextval ,
Nextval>100 and Nextval<=200,Nextval+1,
Nextval>200 and nextval<=300,nextval+2 ,

Nextval>900 and nextval<=1000,nextval+10,0 )