performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Answer Posted / soujanya
before cache joiner after cache lookup
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
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
What is meant by lookup transformation?
How to extract the informatica rejected data?
What do you mean by filter transformation?
Difference between Target-based loading and constraint-based loading?
what is diff b/t sorter t/r and agg have the option sorter property...
Define update strategy?
What is xml source qualifier transformation in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the types of presistent cache in look up tr.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you use reject loader.