can we override a native sql query within informatica? Where do we do it? How do we do it?
No Answer is Posted For this Question
Be the First to Post Answer
Define Incremental Aggregation?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
What is the difference between OLTP and ODS?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What is the difference between Bulk Load and Normal Load
where is the reject loader .
Define Update Override?
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
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
Why we use stored procedure transformation?
What is the use of an aggregator cache file?