Interested to Buy Any Domain ? << Click Here >> for more details...
How can the following be achieved in 1 single Informatica Mapping. * If the Header table record has error value(NULL) then those records and the corresponding child records in the SUBHEAD and DETAIL tables should also not be loaded into the target(TARGET1,TARGET 2 or TARGET3). * If the HEADER table record is valid, but the SUBHEAD or DETAIL table record has an error value (NULL) then the no data should be loaded into the target TARGET1,TARGET 2 or TARGET3. * If the HEADER table record is valid and the SUBHEAD or DETAIL table record also has valid records only then the data should be loaded into the target TARGET1,TARGET 2 and TARGET3. =================================================== HEADER COL1 COL2 COL3 COL5 COL6 1 ABC NULL NULL CITY1 2 XYZ 456 TUBE CITY2 3 GTD 564 PIN CITY3 SUBHEAD COL1 COL2 COL3 COL5 COL6 1 1001 VAL3 748 543 1 1002 VAL4 33 22 1 1003 VAL6 23 11 2 2001 AAP1 334 443 2 2002 AAP2 44 22 3 3001 RAD2 NULL 33 3 3002 RAD3 NULL 234 3 3003 RAD4 83 31 DETAIL COL1 COL2 COL3 COL5 COL6 1 D001 TXX2 748 543 1 D002 TXX3 33 22 1 D003 TXX4 23 11 2 D001 PXX2 56 224 2 D002 PXX3 666 332 ======================================================== TARGET1 2 XYZ 456 TUBE CITY2 TARGET2 2 2001 AAP1 334 443 2 2002 AAP2 44 22 TARGET3 2 D001 PXX2 56 224 2 D002 PXX3 666 332
3 11881How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
2 14988Post New Mphasis Informatica Interview Questions
- Mphasis C Interview Questions (3)
- Mphasis OOPS Interview Questions (3)
- Mphasis C++ General Interview Questions (3)
- Mphasis MFC Interview Questions (7)
- Mphasis Programming Languages AllOther Interview Questions (1)
- Mphasis VB Script Interview Questions (2)
- Mphasis SNMP Interview Questions (3)
- Mphasis Protocols AllOther Interview Questions (1)
- Mphasis Networking Administration Interview Questions (2)
- Mphasis Networking AllOther Interview Questions (1)
- Mphasis C Sharp Interview Questions (11)
- Mphasis ASP.NET Interview Questions (6)
- Mphasis Oracle General Interview Questions (2)
- Mphasis Oracle AllOther Interview Questions (2)
- Mphasis SQL Server Interview Questions (1)
- Mphasis DB Administration Interview Questions (2)
- Mphasis Windows Threads Interview Questions (3)
- Mphasis Linux Commands Interview Questions (1)
- Mphasis Solaris AllOther Interview Questions (4)
- Mphasis QTP Interview Questions (9)
- Mphasis Manual Testing Interview Questions (16)
- Mphasis Test Cases Interview Questions (2)
- Mphasis COBOL Interview Questions (5)
- Mphasis DB2 Interview Questions (4)
- Mphasis RPG400 Interview Questions (1)
- Mphasis Core Java Interview Questions (3)
- Mphasis Struts Interview Questions (2)
- Mphasis Weblogic Interview Questions (1)
- Mphasis SOAP Interview Questions (1)
- Mphasis Teradata Interview Questions (4)
- Mphasis Business Objects Interview Questions (3)
- Mphasis Cognos Interview Questions (5) Mphasis Informatica Interview Questions (5)
- Mphasis Data Stage Interview Questions (1)
- Mphasis HR Questions Interview Questions (4)
- Mphasis Project Planning Interview Questions (3)
- Mphasis Project Management Interview Questions (1)
- Mphasis SAP ABAP Interview Questions (1)
- Mphasis SAP SD (Sales & Distribution) Interview Questions (2)
- Mphasis SAP MM (Material Management) Interview Questions (1)
- Mphasis SAP FI-CO (Financial Accounting & Controlling) Interview Questions (3)
- Mphasis Siebel Interview Questions (2)
- Mphasis WebMethods Interview Questions (2)
- Mphasis Electrical Engineering Interview Questions (1)
- Mphasis Electronics Communications Interview Questions (1)
- Mphasis Banking Finance Interview Questions (2)
- Mphasis Taxation Interview Questions (3)
- Mphasis Accounting General Interview Questions (3)
- Mphasis Accounting AllOther Interview Questions (3)
- Mphasis Call Centre AllOther Interview Questions (39)
- Mphasis Funny Interview Questions Interview Questions (2)
- Mphasis Everything Else AllOther Interview Questions (2)
- Mphasis General Aptitude Interview Questions (3)
- Mphasis Placement Papers Interview Questions (2)
- Mphasis Certifications AllOther Interview Questions (1)
- Mphasis L1 Visa Interview Questions (2)
- Mphasis USA Dependent Visa H4 Visa Interview Questions (1)
- Mphasis USA AllOther Visa Interview Questions (1)
Can you explain what a photoshop lightroom?
What is the maximum size of an array?
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.
Described the point of email marketing?
What is the difference between facades vs helper functions?
How many partitions a clustered index has by default in sql server 2012?
Why are there errors with the macromedia.css.locatorparser class and weblogic?
What is jpanel swing?
Can android run javafx?
What is 'sleep' in sync point?
How will you cancel a deployment from central admin -> solution management, if it’s stuck at ³deploying´ or ³error?
What is scaffolding in cakephp?
What is the is the default transaction factory in hibernate?
How do I disable windows defender?
What is IaC in DevOps?
