Interested to Buy Any Domain ? << Click Here >> for more details...
why we r using presql&postsql in source qualifier?
- 1 Answers
- 6128 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
Presql :sql statement executed before the session retrive
the data from source.
Postsql:sql statement executed atfer the session retrive the
data from source.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Write the advantages of partitioning a session?
is it possible to index the data in cache of lkp transformation ?
What is informatica etl tool?
what is INFORMATICA TESTING process
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
How to join three sources using joiner?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to create Target definition for flat files?
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 many number of sessions can one group in batches?
What is informatica powercenter repository?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Why filter transformation is an active one?
update strategy transformation in informatica
What are the various types of transformation?
