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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How can we update a record in the target table without using update strategy?

0 Answers  


we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  


Explain constraint based loading in informatica

0 Answers   Informatica,


How can a transformation be made reusable?

0 Answers   Informatica,


What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,






Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,


Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  


Explain the etl program with few examples.

0 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  


How to delete the data in the target table after loaded.

3 Answers   TCS,


how do u move the code from development to production?

3 Answers  


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


Categories