 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?
Answer Posted / sarat
The above method tells us how many are missing, after that take the TARGET as Dynamic LKP and update the target for All rows to be loaded
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between a connected lookup and unconnected lookup?
Which transformation is needed while using the Cobol sources as source definitions?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
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.
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the components of workflow manager?
How do you load only null records into target? Explain through mapping flow.
How to delete duplicate row using informatica?
how to load rows into fact table in data warehouse
what is $$$$?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
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)
Can anyone tell me the new features in Informatica 9 Version?
What is an unconnected transformation?
What will be the approach?