Answer Posted / amedela chandra sekhar
By using the condition in router transformation
drop the required ports into router t/r
add one group
even mod(empno,2)=0 ------Target1
defaultgroup -------------Target2
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the performance considerations when working with aggregator transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Briefly define a session task?
Different sorts of metadata that stores in the storage facility?
What are the reusable transformations?
In how many ways we can create ports?
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?
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
what is the size of u r source(like file or table)?
How we can create indexes after completing the load process?
Different qualification between a related rotate toward the sky and isolates look upward?
Explain informatica architecture - version 8 / 9
How to use procedural logic inside infromatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.