Interested to Buy Any Domain ? << Click Here >> for more details...
On lookup on any table we can get only a)any value or b)last
value but if i need both duplicate values How can i achieve?
- 3 Answers
- 7077 Views
- I also Faced
- E-Mail Answers
Answer Posted / pradeep
We wil go for left outer join on the lookup table in the
source qualifier sql override so that it wil return both the
records.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you understand by a term domain?
What is a node in Informatica?
What is the benefit of partitioning a session?
What is parallel processing in informatica?
What is blocking transformation?
Clarify the aggregator change?
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 the use of source qualifier?
can you please explain me pre session and post session options?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the fact table?
Can we get 1st record through Informatica(without sequence number).
Explain why we use partitioning the session in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
if we have a delimiters at unwanted places in a flat file how can we over come those.
