Interested to Buy Any Domain ? << Click Here >> for more details...
What is a look up function? What is default transformation
for the look up function?
- 2 Answers
- 17292 Views
- ASM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri
Lookup is a transformation in Informatica which is mainly
used for obtaining the "Key" values from the dimensions.
Lookup can be connected or unconnected. If it is
unconnected then it can be used as a function but it can
return only one value.
Where as connected lookup return more than one value.
Lookup contains:
1. <Input Column/Value>
2. <Output Column(s)>
3. <Condition>
| Is This Answer Correct ? | 12 Yes | 4 No |
Answer / guest
look up compares the source to target.it update and insert
the new rows to the target.
the default transformation for look up is source qualifier
| Is This Answer Correct ? | 13 Yes | 9 No |
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
What is meant by lookup transformation? Explain the types of lookup transformation?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
What is best approach to load 100 different source files (Different structure) to differet target tables ?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
What are the types of data that passes between informatica server and stored procedure?
What is the format of informatica objects in a repository?
Teradata 
