what is the predefined port in dynamic lookup
Answers were Sorted based on User's Feedback
Answer / moorthy g
NEWLOOKUPROW
Note: We can't edit the port:
NEWLOOKUPROW = 0 (No Changes)
NEWLOOKUPROW = 1 (Insert)
NEWLOOKUPROW = 2 (Update)
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the types of maping wizards that r to be provided in Informatica?
how to through logic of informatica using the push down optimization into oracle.
what is normalization? explain 1st NF, 2nd NF, 3rd NF
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
How to recover the standalone session?
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
what is difference between COM & DCOM?
how to get max value record into one target and remaining records into another target?
What are the new features of informatica 9.x in developer level?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What does reusable transformation mean?