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
- 7794 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
How would you copy the content of one repository to another repository?
What does “tail –f” command do and what is its use as an Informatica admin.
tell me 5 session failure in real time how can you solve that in your project?
Define the various join types of joiner transformation?
what is $$$$?
What is the need for an etl tool?
Which are the different editions of informatica powercenter that are available?
what are the deliverables?in your project?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is repository manager?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the reusable transformation?
Explain lookup transformation in informatica
tell me the rules and responsblites in our project(my project is development)
What is Data Caches size?
