if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
- 2 Answers
- 5600 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinu
unonnected lookup
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What do think which one is the better joiner or look up?
what is the size of u r source(like file or table)?
What is a joiner transformation and why it is an active one?
What is the Rank index port in Rank transformation?
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
What is deployment group?
What is sorter transformation?
How can we delete duplicate rows from flat files?
differences between service based and product based?
lookup transformation with screenshots
Mention few power centre client applications with their basic purpose?
What is a joiner transformation?
Explain the pipeline partition with real time example?
What are the different types of repositories created using informatica?
How to use pmcmd utility command?
