How can i send first half of the records to one target and
Remaining to other target?
- 10 Answers
- 26902 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / triveni
first pipeline copy nextval port to expression
create one dummy outputport assign 1
second pipeline
deptno decimal 20
totalrecord decimal 10 0 count(deptno)
create another dummy port
dummy decimal 10 0 assign 1
joiner tr common port from 2 pipelines dummy
empno,dummy(detail),totalrecord,dummy1(master)
condition:dummy1=dummy
jointype:normal
router:
nextval<totalrecord/2
nextval>totalrecord/2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the difference between router and filter?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Differentiate between a repository server and a powerhouse?
What could be the possible resons of locks by user?
Explain sessions and how many types of sessions are there?
how we can load rejected record's at run time?(not through bad files)
What is target load order?
can anyone explain me about retail domain project in informatica?
What all are steps in up gradation of Informatica server?
What is Cognos script editor?
list out all the transformations which use cache?
What is joiner transformation in informatica?
What are the transformations that are not supported in mapplet?
