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 11997How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
2 15072Post 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)
What is the extension of master page in asp.net?
What is spark dynamic allocation?
What does tcp/ip stand for?
How do I show margins in word 2007?
Can we do sorting in XSL ? how do you deal sorting columns dynamically in XML.
Define the material taxes in ovk4, which will then be maintain in material master.
What is mysqli_connect_error ()?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Is entitymanager thread safe?
What is an xsd file?
Explain the concept of separation of concerns and it's pros and cons.
Explain queue. How it can be implemented?
What is monopolistic competition in marketing sales?
When the recid is generated, what is its utility?
What is outputs?
