Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7807 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 |
TELL ME ABOUT WORK FLOW SCHEDULING?
Explain what are the different types of transformation available in informatica.
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What are ETL Tools?
What is the difference between STOP and ABORT options in Workflow Monitor?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
How to load the data from a flat file into the target where the source flat file name changes daily?
how to load duplicate row in a target
Explain joiner transformation in informatica
Teradata 
