Interested to Buy Any Domain ? << Click Here >> for more details...
when will we go for unconnected lookup transformation in
Informatica?
- 6 Answers
- 24469 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / balu
above cases as well as if you want to get single port from
the lookup table then you should go for unconnected lookup
transformation.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is informatica worklet?
How can we use mapping variables in informatica? Where do we use them?
What are the various types of transformation?
What is a filter transformation and why it is an active one?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is target load order?
Write the unconnected lookup syntax?
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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is depict expression change?
How many numbers of sessions can one group in batches?
where to store informatica rejected data?
What is the way to execute pl/sql script using informatica mapping?
What is the need for an etl tool?
What is a transaction control transformation?
