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
How can we update a record in the target table without using update strategy?
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?
Explain constraint based loading in informatica
How can a transformation be made reusable?
What are mapplets? How is it different from a Reusable Transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
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.
Explain the etl program with few examples.
Write the prerequisite tasks to achieve the session partition?
How to delete the data in the target table after loaded.
how do u move the code from development to production?
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 ?