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
- 29264 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
expain about the tune parameters?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is substr in informatica?
What are the components of Informatica? And what is the purpose of each?
How does a sorter cache works?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain direct and indirect flat file loading (source file type) - informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the command used to run a batch?
How to load a Dimension ? and how to load a fact table?
Separate from an archive server and a powerhouse?
What is sq transformation?
What are pre and post-session shell commands?
How to improve the performance of a session using sorter transformation?
Design time, run time. If you don't create parameter what will happen
