what is the main advantage of unconnected lookup
Answers were Sorted based on User's Feedback
Answer / praveen sh
If the same lookup table is used multiple times in the same
mapping, then it is better to go for un connected lookup.
Doing so we save cache memory and enhence performence
| Is This Answer Correct ? | 15 Yes | 0 No |
without update strategy how to insert &update?
what is the command to get the list of files in a directory in unix?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
tell me the informatica architecture
major difference between normal loading and bulk loading?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
what are 3 tech challenges/ common issues you face?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How can you validate all mappings in the repository simultaneously?