How many ways a relational source definition can be updated and what are they?
No Answer is Posted For this Question
Be the First to Post Answer
What is parameter file?
What is the use of source qualifier?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Can you use one mapping to populate two tables in different schemas
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
What are the tasks that Loadmanger process will do?
without dynamic lookup transformation how to insert new rows and update existing rows?
How can u work with remote database in informatica?did you work directly by using remote connections?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
explain different types of modeling.
Quickly characterize reusable change?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.