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 .
Answer / weff
Every one has its own Importence,
Every one will Dependent on other one,
Choose The Carrier as a Jnuior Role,,,,
| Is This Answer Correct ? | 0 Yes | 1 No |
What is difference between stored procedure transformation and external procedure transformation?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
How to display null values on a target & non-null values on a target?
what is the significance of newlookup port in dynamic look up
Differentiate between a repository server and a powerhouse?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
What is partioning?how many types of partinings are there
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?