 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?
Answers were Sorted based on User's Feedback
Answer / vikram
While populating to target rejected loads will be loaded in
to bad files and we can cross check the data there and the
other way is run the load in verbose mode to check the
exact reason this happens when the flat file data is not in
correct format.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
What is the benefit of partitioning a session?
How do you take back up of repository?
What are roles and groups and benefits of using them?
How many ways are there to do 'remove duplicate records in informatica'?
Where can we find the throughput option in informatica?
in performance wise union is past,union all is past
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
How to load the source table into flat file target(with columns) in informatica?
Explain what are the different types of transformation available in informatica.
what is shortcut in informatica? difference between shortcut,reusable object?
What is the use of source qualifier?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.