 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 |
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
what is diff between grep and find
What are the steps involved in the migration from older version to newer version of Informatica Server?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
What is the role of informatica in project ?Like i showed financial projects?
Sequence generator, when you move from develoment to production how will you reset
How many ways you create ports?
Different sorts of metadata that stores in the storage facility?
How are indexes created after completing the load process?
How the informatica server sorts the string values in Rank transformation?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .