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 12046How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
2 15114Post 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)
Name of the companies listed in sensex ?
the maximum length of a character constant can be a) 1 character b) 8 characters c) 256 chaacters d) 125 characters
What are the features of message broker?
What is a machine shop?
What is jhttp web server?
What kind of things have you done on the social side?
What is the difference between using constructor vs getInitialState in React?
You want to see if you have a queue in ebp, how will you do it?
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com
Do you know function of hydro extractor machine?
If it were up to you, what would the budgeting process look like?
How you can convert a number to a string?
Explain the difference between overloading and overriding?
what is the specification for the modem pin
How do you start developing a datastage project?
