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 11996How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
2 15070Post 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 normal table capacity for gathering data?
What two properties of electromagnetic waves are used to attach info to radio signals?
Situation: you need to move data or databases between servers. What steps will you take?
What is a goal in maven terminology?
what do you mean by "Closures with help of Top Management and Colleagues"
Explain transformation and action in RDD in Apache Spark?
How do you remove all elements from an arraylist in java?
How will you make a field mandatory in maintenance notification for a certain notification type?
Is there any limited number of simultaneous sessions of a sap maxdb database?
How do I convert pdf to xml?
What is a nested class?
What happens if a try-catch-finally statement does not have a catch clause to handle an exception that is thrown within the body of the try statement?
How do I start excel?
What is 'bill of exchange' (boe)?
How do you maintain promotions in sap is retail?
