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
- 17175 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 |
Why sorter is an active transformation?
Plz..let me know differences between Informatica 7.1 and 8.1?
what is the command to get the list of files in a directory in unix?
can we override a native sql query within informatica? Where do we do it? How do we do it?
While importing the relational source defintion from database,what are the meta data of source U import?
what are presession,postsession success and postsession failure commands ?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
Different qualification between a related rotate toward the sky and isolates look upward?
How can we use mapping variables in informatica? Where do we use them?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
What is the need of etl tools?
Teradata 
