I am getting five sources in a day and i donot know when i
get them. i need to load data into the target and run the
session. but here i can't keep the session in running or
can't stop the session. plz help me
Answer Posted / veeras
hi,
using EventWait we can load the data once we get the source.
Event wait 'll wait for the readiness of source data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is informatica metadata?
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
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How would you copy the content of one repository to another repository?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the popular informatica products?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is a node in Informatica?
What is data transformation manager process?
What are some examples of informatica etl programs?
What is incremental aggregation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain the types of lookup transformation?
Write the different tools in the workflow manager?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,