What is the need of an ETL tool?
No Answer is Posted For this Question
Be the First to Post Answer
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 have a delimiters at unwanted places in a flat file how can we over come those.
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
What is an Integration service in Informatica?
Define mapping and session?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that