Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Mention few advantages of router transformation over filter transformation.

1021


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 ?

7229


explain abt ur project architecture?

2186


where to store informatica rejected data?

1093


What are Dimensional table?

1053


During the running session, output files are created by informatica server. Enlist few of them.

976


What is decode in informatica?

1148


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

2098


Make a note of the quantity vaults made in informatica?

988


What is informatica metadata and where is it stored?

989


what is the size of your data warehousing?

2091


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,

7182


What is the use of an aggregator cache file?

1199


what is SDLC way of code development?

2038


Differentiate between joiner and lookup transformation?

1100