Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ashish
Lookup by default perform normal join but if you want to achieve left outer ,right outer , full outer join . you can do so by SQL override in lookup
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what are the concerns of OLTP and DSS systems?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
what are the production issues in datastage?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
Explain what are the various etl tools in the market?
What is partitioning? Explain about round-robin, hash partitioning.
explain the methodology of Data Warehousing?(Polaries)
What are the various tools used in etl?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is the difference between cardinality and Nullability?
Define Dynamic push down optmization?
Identifying the bottlenecks in various components of Informatica and resolving them.
