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
- 10554 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 |
Write the advantages of partitioning a session?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
how to use incremental load?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
To import the flat file definition into the designer where should the flat file be placed?
What are the components of workflow manager?
How can repository reports be accessed without sql or other transformations?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
what is the main advantage of unconnected lookup
What are the different ways to implement parallel processing in informatica?
How many mapplets u have created? and what is the logic used
What is confirmed fact in dataware housing?
Teradata 
