 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 / 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 |
Post New Answer View All Answers
What are the main issues while working with flat files as source and as targets ?
Can you generate sequence numbers without using the sequence generator transformation?
explan ur project architecture?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to update a particular record in target with out running whole workflow?
can we override a native sql query within informatica? Where do we do it?
How can a transformation be made reusable?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Different sorts of metadata that stores in the storage facility?
Plz can any one say me how to get the informatica certification materials and dumps
expain about the tune parameters?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain what is informatica metadata and where is it stored?
What does reusable transformation mean?