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.
Answer Posted / 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 |
Post New Answer View All Answers
What is deployment group?
What is the meaning of decode in informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can you increase the performance in joiner transformation?
Explain sessions. Explain how batches are used to combine executions?
Is there any target staging area in informatica not staging area
How do you load alternate records into different tables through mapping flow?
What is the advantage of informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is an expression transformation?
can u any challenge your project?
define galaxy repository in informatica
Explain the aggregator transformation?
How can one identify whether mapping is correct or not without connecting session?
What are connected or unconnected transformations?