HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?
Answer Posted / vino
you can give the next val of the seq generator to the
expression which produces a sequence for all the incoming
records.then create an output port in the expression with
the calculation (incoming_seq mod 2) which will produce
either 0 or 1..then after that use a router creating groups
1 and 0...then load into the 2 targets.
Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Explain your project of banking domian.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How can a transformation be made reusable?
What are the mapping parameters and mapping variables?
How many transformations can be used in mapplets.
What is a snowflake schema?
What is the sequence generator transformation in informatica?
have u done any performance tuning? how u ll do?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How do you load only null records into target? Explain through mapping flow.
What is workflow? What are the components of workflow manager?
What is informatica? Why do we need it?
What is union transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.