Interested to Buy Any Domain ? << Click Here >> for more details...
 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?
- 2 Answers
- 8084 Views
- DELL, I also Faced
- E-Mail Answers
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 |
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 are the ETL tools available in DWH?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
can u give example for factless fact table
How an expression transformation differs from aggregator transformation?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
What are the different lookup cache(s)?
How can we remove the duplicates from flat file source?
HOW TO GET THE LATEST DATA IN SCD ?
Explain the types of transformations?
Teradata 
