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
- 10676 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 anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What are junk dimensions?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what are types of dimentions?
To provide support for Mainframes source data,which files r used as a COBOL files
How can you define a transformation? What are different types of transformations in Informatica?
What is meant by incremental aggregation?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
what is the difference between repository & Intergration service
How do you update the records with or without using update strategy?
Teradata 
