hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 16151 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / reddy
hi,
we can eliminate duplicate values by camparision primary key
using lookup
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is rank index in rank transformation?
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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How can a transformation be made reusable?
What does role playing dimension mean?
What are the different versions of informatica?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Define filter transformation?
Did u used latest transformations of 8.6.0? for what?
How many ways are there to do 'remove duplicate records in informatica'?
How we can use union transformation?
What are the components of workflow manager?
Define mapplet?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
