How do you load unique records into one target table and duplicate records into a different target table?
No Answer is Posted For this Question
Be the First to Post Answer
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Could any one to tell How to use the Oracle Analytic functions in Informatica?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
Why we use partitioning the session in informatica?
What is IQD file?
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Which transformation should we use to normalise the COBOL and relational sources?
How does a sorter cache works?