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?
Answer Posted / dharmendra singh
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 |
Post New Answer View All Answers
In warehouses how many schemas are there?
what are the Methods For Creating Reusable Transformations?
Mention a few design and development best practices for informatica?
can you please explain me pre session and post session options?
Different sorts of metadata that stores in the storage facility?
How to load the data from people soft hrm to people soft erm using informatica?
How can informatica be used for an organization?
What is standalone command task?
Differentiate between a database and data warehouse?
What is parallel processing in informatica?
What are roles and groups and benefits of using them?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Explain lookup transformation is active in informatica
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the limitations of joiner transformation?