 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 data modelling? what are types of modelling?In which suituation will use each one?
Explain about Recovering sessions?
Why we use partitioning the session in informatica?
Which is costliest transformation? costly means occupying more memory?
How can yoU improve session performance in aggregator transformation?
Can we call a stored procedure from a unix script which is run using command task
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
how do u fnd the duplicate rows and how to delete the duplicate rows?
What is a filter transformation?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
Describe expression transformation?
what is mystery dimension?