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 12103How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
2 15179Post 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 are the advantages of user defined function?
why does connected a indutor with mnsformeretering core of current transformer ?
what are the informix isolation levels and can you explain each one ?
Explain the method to remove a budget.
How do you turn off safe mode?
How to find a substring from a given string in php?
Explain inductance?
What is the difference between set and select?
What is session mode in asp.net?
Can we maintain user session in web services?
What are the versions of ubuntu?
Why is data mining hot cake topic for this generation?
What is pipe command in unix?
What do you mean by default constructor?
What do the compilers provide?
