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
- 7778 Views
- ACS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is mean by complex business rule ?
What is a joiner transformation?
What is session task and command task?
What is update strategy transform?
What is the benefit of partitioning a session?
How big was your fact table
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is joiner change?
update strategy transformation in informatica
What is the use of an aggregator cache file?
Can you generate sequence numbers without using the sequence generator transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to open an older version of an object in the workspace?
Differentiate between joiner and lookup transformation?
What is pmcmd command?
