Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mayuri
Select ditinct in properties of source qualifier
transformation.
| Is This Answer Correct ? | 21 Yes | 6 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
Explain the types of transformations?
How to update a particular record in target with out running whole workflow?
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 are the settings that you use to configure the joiner transformation?
How to join three sources using joiner?
How to do unit testing in informatica? How to load data in informatica ?
What are the different clients of powercenter?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
how to load dimension table and fact table. plz tell me the steps.
what is INFORMATICA TESTING process
How to use procedural logic inside infromatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the use of source qualifier?
