How we can get unique records into one target table and
duplicate records into another target table??
Answer Posted / chetan
I/p
A
B
B
C
D
D
need to load A.C in one tgt and B,B,D,D in another target table.
SQ o/p should be given to aggregator. group by first column.create another port(v_count) with count(*).
SQ o/p should be passed to joiner to join aggr and SQ(source).
o/p looks like after joinning
A 1
B 2
B 2
C 1
D 2
D 2
use router to route v_count=1 and v_count=2 to different targets.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is informatica powercenter repository?
Enlist the tasks for which source qualifier transformation is used.
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the differences between source qualifier and joiner transformation?
Explain the features of connected and unconnected lookup.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Sequence generator, when you move from develoment to production how will you reset
What is resilience time?
Explain pmcmd command usage in informatica
What is an active transformation?
On which transformations you created partitions in your project?
Design a mapping to load the cumulative sum of salaries of employees into target table?
how tokens will generate?