Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 25927 Views
- I also Faced
- E-Mail Answers
Answer Posted / parveen kumar
The imp. diff b/w connected and unconnected lookup is regarding to their performance. Suppose if a lookup condition is true only for one thousand rows out of 1M rows. Then we must use unconnected lookup in such cases by calling the lookup only in else condition i.e. we can write in EXP that if ID(suppose this is I/N port)is null, then -1 else :LKP.(lookup transformation name). So in this case, it'd hit the DB only 1000 times. But if we use connected lookup, it'd hit the DB 1M times no matter whether the condition is true or not.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How do you handle two sessions in Informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a filter transformation?
can we override a native sql query within informatica? How do we do it?
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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is update strategy transform?
What is a connected transformation?
What are multi-group transformations?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to generate or load values in to the target table based on a column value using informatica etl tool.
what are 3 tech challenges/ common issues you face?
