If source is having 5000 rows,and if you want to load data
into 500 rows to target,if the session runs successfully,how
can you verify the target if the rows are successfully
loaded or not.
Answers were Sorted based on User's Feedback
Answer / abhishek upadhyay
Through session log/run properties I can see how many rows
were inserted in the target table
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / raveendra g
By using Testload option, we can test the rows.
| Is This Answer Correct ? | 4 Yes | 1 No |
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
what is difference between dimention table and fact table?
What is the difference b/w natural key and surrogate key
what is the necessity to use update strategy?(except for updates)
without dynamic lookup transformation how to insert new rows and update existing rows?
What are the types of data that passes between informatica server and stored procedure?
Implementation methodology
what is difference between COM & DCOM?
What are the advantages of informatica?
what are the limitations of pushdown optimization technique ? Advance thanks
why we use stored procedure transformation?
why union is active transformation?