my table contain duplicate Records i wanna load uniq records
to my table . i have to pass the uniq records through
filter t/r how?
- 3 Answers
- 6582 Views
- ACS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pavana
Yes, Sort the data first , then in expression increment the
count based on theprev value . in filter give condition if
count =0 . it pass only unique value.
sd >> SQ>> SRT TRN>> EXP>> FIL>> TGT.
| Is This Answer Correct ? | 1 Yes | 0 No |
Use a sorter transformation after source qualifier.check
unique records in the proprrties of sorter,This will [ass
only unique record from the sorter.
| Is This Answer Correct ? | 1 Yes | 2 No |
what is the necessity to use update strategy?(except for updates)
What is the way to execute pl/sql script using informatica mapping?
What are active transformations.
How does the server recognize the source and target databases. Elaborate on this.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
major difference between normal loading and bulk loading?
Differentiate between source qualifier and filter transformation?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
What are the different types of Type2 dimension maping?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Teradata 
