why we use source qualifier transformation?
Answer Posted / vankayalapati sankar
souce qualifies transformation we can use to reduce the perfomence tunning pupose and minimum four transformations cover in it.what are those 0ne resone two join the two table in this case we can use the joiner transfomation,secound resone filter condition applied in source filter option in source qualifier transformation in that case filter tranformation cover it.third resone distinct option we can use to dublicate records remove in that case sorter tranformation cover.fourth resone sql qerry write in sql qerry option use it.in that case lookup transformation cover
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
explain abt ur project architecture?
where to store informatica rejected data?
What are Dimensional table?
During the running session, output files are created by informatica server. Enlist few of them.
What is decode in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Make a note of the quantity vaults made in informatica?
What is informatica metadata and where is it stored?
what is the size of your data warehousing?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is the use of an aggregator cache file?
what is SDLC way of code development?
Differentiate between joiner and lookup transformation?