Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important
- 4 Answers
- 10303 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / usha
by using dynamic lkp its possible...
in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...
when ever data inserted in to the target cache get
refreshed..
we ttake dynamic lkp..
by defaul..new lkp row port is added...
we should enable the associatve port...
here we should give the condition ..
in router we should give condition as newlkp=1--it will
insert...
if newlkp=0 means duplicate recorts
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
explain one complex mapping with logic? sales project?
Under what condition selecting sorted input in aggregator may fail the session?
During the running session, output files are created by informatica server. Enlist few of them.
Can anyone tell me the new features in Informatica 9 Version?
Briefly describe lookup transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the different options available for update strategy?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the different types of repositories created using informatica?
What are connected or unconnected transformations?
How to Create a folder using pmrep command?
What is data movement mode in Informatica and difference between them?
Why update strategy and union transformations are active?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
