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.
No Answer is Posted For this Question
Be the First to Post Answer
What are the limitations of joiner transformation?
how many types transformations supported by sortedinput?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to delete the data in the target table after loaded.
What are active and passive transformations?
What can we do to improve the performance of informatica aggregator transformation?
what is data driven in update strategy transformation?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
what is the complex transformation you used in informatica
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is transformation?