Answer Posted / saribalareddy
Whenever you create the target table whether you are store the historical data or current transaction data in to target table.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is workflow monitor?
What could be the possible resons of locks by user?
How to delete duplicate row using informatica?
Explain the different kinds of facts.
expain about the tune parameters?
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
What is a stored procedure transformation?
What are session parameters ? How do you set them?
What all join we can perform in LOOKUP transformation?
What is intricate mapping?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the difference between informatica 7.0 and 8.0?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the sql query overwrite in source qualifier in informatica