Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance
issue. how to fix the performnce issue of the query.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the Differences between static cache and dynamic cache?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What is partioning?how many types of partinings are there
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
When to use normalization transformation other than cobol source?
When do you use mapping parameters? (In which transformations)
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
normalizer transformation
what is shortcut in informatica? difference between shortcut,reusable object?
without using emailtask how will send a mail from informatica?
what is parameter file?