What are conformed dimensions?
The dimension which can be shared more than 1 fact/module called a conformed dimension. Eg: Time dimension
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the flow of data in Iinformatica?
how may sources can be used in a mapping at a time?(limit)
what are the transformations that restricts the partitioning of sessions?
Define the various join types of joiner transformation?
Tell me about Propagate functions in informatica
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
What will be the approach?