Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / lalamaheshkumar
small correction for above ..
Hi for the above question you are going to get the suresh
record twice if you select rank as three (3) . to get the
distinct records , in source qualifier put a distinct
clause in the query .. then you will get the correct result.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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 the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
have u done any performance tuning? how u ll do?
What are the differences between joiner transformation and source qualifier transformation?
What are the components of Informatica? And what is the purpose of each?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Difference between Target-based loading and constraint-based loading?
What is a node in Informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the advantages of informatica?
Can we create a Integration service without a Repository service and vice versa?
How many ways a relational source definition can be updated and what are they?
What is Session and Batches?
How can repository reports be accessed without sql or other transformations?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
