 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 / 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 |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a difference between complete, stop and abort?
difference between repository database and repository service?
how to load rows into fact table in data warehouse
what is the Default Source Option For Update Strategy Transformation?
What is a joiner transformation?
Can you use flat files in Mapplets.
What is dimensional table?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
lookup transformation with screenshots
What is deployment group?
What are the different components of powercenter?
What are the different types of transformation available in informatica.
What is a snowflake schema?
How to elaborate powercenter integration service?