Answer Posted / sai suresh
I think look up is a transformation it is mostly used for
slowly changed dimenctions(SCD). with the help of look up
T/R we can join to dimention tables. These tables may
Hetrogonies tables
Posni_sai@yahoo.com
sai suresh
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why do you use Mapping Parameter and mapping variable?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Enlist few areas or real-time situations where informatica is required.
What are the various types of transformation?
Clarify the aggregator change?
What is a joiner transformation and why it is an active one?
How can we use mapping variables in informatica? Where do we use them?
What is a grid in Informatica?
What are the tuning techniques you applied during your last project
Difference between Target-based loading and constraint-based loading?
How to extract sap data using informatica?
What is sq transformation?
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.
Describe the impact of several join conditions and join order in a joiner transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
