Interested to Buy Any Domain ? << Click Here >> for more details...
Why we use lookup transformations?
- 1 Answers
- 6295 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 |
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is lookup transformation?
what is shared Cache. when we will use shared Cache?
Explain Dataware house architecture .how data flow from intial to end?
what is mapping parameter and mapping variables
What is deployment group?
how can we run workflow with pmcmd?
Enlist the differences between database and data warehouse.
What are the tuning techniques you applied during your last project
Slowly changing dimensions, types and where will you use them
How you can differentiate between connected lookup and unconnected lookup?
Teradata 
