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
- 7630 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 Session and Batches?
Explain how many types of dimensions are available in informatica?
Different sorts of metadata that stores in the storage facility?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the uses of etl tools?
Where can we find the throughput option in informatica?
Write the unconnected lookup syntax?
Differentiate between source qualifier and filter transformation?
What is the status code in stored procedure transformation?
What is sequence generator transformation in informatica?
what is mean by complex business rule ?
Explain the different dimensions.
How can we use mapping variables in informatica? Where do we use them?
What are the different types of repositories created using informatica?
Explain scd type 3 through mapping.
