1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

While migrating the data from one environment to another environment how would you manage the connections?

Question Posted / nipun kumar


While migrating the data from one environment to another environment how would you manage the connec..

Answer / Mohd Roshan Pasha

Managing connections during migration in Informatica can be achieved through several methods. Firstly, you could use Connection Manager Migration utility which allows you to migrate all connection information from one environment to another. Secondly, you can save and load the connections using the Connections Export/Import function available in PowerCenter. Lastly, updating the Connection Properties file directly is also an option but it's not recommended as it may lead to errors.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

Enlist the various types of transformations.

1 Answers  

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

How to recover sessions in concurrent batches?

1 Answers  

waht type of interface is used for testing the data in informatica

1 Answers   CTS, TCS,

what is the architecture of any Data warehousing project?

5 Answers   IBM,

what is correlated query?

2 Answers   IBM,

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

For more Informatica Interview Questions Click Here
Categories