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 |
What are the Differences between static cache and dynamic cache?
What are the uses of etl tools?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What is an MDDB? What is the difference between MDDBs and RDBMSs?
What is Java Transformation? what are the uses of it?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
What are active and passive transformations?
Why touse stored procedure in ETL Application?
How to use Normalizer transformation?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
What is IQD file?
which one is better either active or passive transformation in informatica