Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kishore
Mainly errors were like null values first we need to process error records into one target and good record into another target by using router transformation.after execution of mapping we check the error file size through unix if error file size is greater than 0 then we will send email to source system team with error file attachments.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is update strategy transform?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How many ways a relational source definition can be updated and what are they?
how many types of dimensions are available in informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the different options available for update strategy?
What is a standalone command task?
Explain the informatica workflow?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain the pipeline partition with real time example?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the etl program with few examples.
Different sorts of metadata that stores in the storage facility?
What is informatica metadata and where is it stored?
Separate from a database, an information bazaar, and an information stockroom?
