What are the challenges of Dataware housing in the future?
Post New Answer View All Answers
What is source qualifier transformation in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How do you convert single row from source into three rows into target?
What will be the approach?
What is aggregator transformation in informatica?
What are the guidelines to be followed while using union transformation?
How to extract the informatica rejected data?
can we override a native sql query within informatica? Where do we do it?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is Active lock explain
What is a sequence generator transformation?
What is substr in informatica?
Differentiate between sessions and batches?
what is size of u r database?
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.