when i was running the seesion, after loading 100 records,
session suddenly fails.Next time i want to load the remaing
rows in target with out truncate target table.What should i
use?
Answer Posted / powerstar
session recovery works much better if it is run in normal mode.
If the load type is bulk mode, then session recovery is compromised.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define the various join types of joiner transformation?
Mention some types of transformation?
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
in reporting we add some new objects,how we get the count of the newly added objects to the report
Differentiate between a repository server and a powerhouse?
have u done any performance tuning? how u ll do?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
how we can load rejected record's at run time?(not through bad files)
What are mapplets?
Explain what are the different types of transformation available in informatica.
What is lookup change?
What differs when we choose the sorted input for aggregator transformation?
tell me the rules and responsblites in our project(my project is development)
what is diff b/t sorter t/r and agg have the option sorter property...