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
Can there be sub steps of etl steps?
What are the modules in Power Mart?
what happens if the info.server doesn't find the session parameter in the parameter file?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what is the use of server manager?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What is partitioning? Explain about round-robin, hash partitioning.
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
When do we analyze the tables? How do we do it?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is pmrep command?
What is Data Vault???
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Identifying the bottlenecks in various components of Informatica and resolving them.
