Why we use lookup transformations?
- 1 Answers
- 5960 Views
- I also Faced
- E-Mail Answers
Answer / guest
we use lookup transformation to lookup data in a relational
table ,view or synonym.and by using lookup transformation
we can perform the following jobs
-to get the related value
-to perform the calculations
-to update the slowy changing dimentions
| Is This Answer Correct ? | 3 Yes | 1 No |
Is it possible to create multiple domains on a single Informatica server?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
without using emailtask how will send a mail from informatica?
My source table having some records ,i want load 1st record and last record into one target?
What is meant by a domain?
Differentiate between a repository server and a powerhouse?
What is the difference between a table and the materialized view?
How do you load only null records into target?
Teradata 
