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
- 10467 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / p1khatri
using Dynamic lookup :-
for new record (i.e. Newlookuprow =1)insert into tgt 1
for duplicate records (i.e. Newlookuprow=0) insert into tgt
2
I hope this'll work
| Is This Answer Correct ? | 7 Yes | 6 No |
Answer / yaseen
sort the records with sorter t/r and with aggregator t/r give the group by and add 1 column give the expression as count(col)and in router t/r give condition as count=1 for unique and default for duplicate.
And I think for dynamic lookup newlookport = 0 then it is for no changes right like
0------no changes
1-------insert
2--------update
Plz correct me if I am wrong
| Is This Answer Correct ? | 1 Yes | 0 No |
can we create index and drop index in exsisting table while using infomatica
What is decode in static cache?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
can u any challenge your project?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
What are the reusable transformations?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
where does the default group roew in a router is stored what is the default size of memory in router
What are differences between Informatica 7.1 and 6.1
What is the use of code page?
What are data-driven sessions?
Teradata 
