What is the main purpose of Unconnected lookup other than
updating slowly changing dimensions?
or In which case u use Unconnected lookup?
Answers were Sorted based on User's Feedback
Answer / ratalarayudu
hi,
The main purpose of unconnected lookup t/r is
1.To update slowly changing dimensions
2.if we want to use the same lookup multiple times in a
mapping we can go for unconnected lookup
3.if we want to lookup on only selected rows then we can go
for unconnected look up.
regards,
rayudu.
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / praveenabhaskar
We can use unconnected lookup transformation when we have
multiple inputs and single output.
Is This Answer Correct ? | 3 Yes | 2 No |
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
with out using update strategy transnsformation how to update the data in mapping level
EXL informatica Questions
How can you increase the performance in joiner transformation?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
How can we use mapping variables in informatica?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
how to run the batch using pmcmd command