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
how the server recognises , if the session fails after loading the 100 records in to the target
What are junk dimensions?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
can you please explain me pre session and post session options?
Tell me about Propagate functions in informatica
Write the prerequisite tasks to achieve the session partition?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
How many ways are there to create ports?
How union transformation is active ?
major difference between normal loading and bulk loading?