Interested to Buy Any Domain ? << Click Here >> for more details...
How can i send first half of the records to one target and
Remaining to other target?
- 10 Answers
- 29692 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
What is status code in informatica?
Explain transaction control transformation in informatica
What is the difference between stop and abort in informatica
Explain pushdown optimization and types in informatica
What are the restrictions of union transformation?
How to load a Dimension ? and how to load a fact table?
Difference between Data and Index Caches?
What is the surrogate key?
What are the types of lookup transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is domain in terms of informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What do you mean by filter transformation?
What are the databases that informatica can connect to windows?
