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
- 29552 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
Is there any target staging area in informatica not staging area
without table how to come first record only in oracle?
How to do the error handling of if ur source is flatfiles?
Under what condition selecting sorted input in aggregator may fail the session?
What is the benefit of partitioning a session?
What are the differences between oltp and olap?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is DR strategy for Informatica project?
How do you load only null records into target? Explain through mapping flow.
What are the types of caches in lookup?
where to store informatica rejected data?
What all join we can perform in LOOKUP transformation?
What is a joiner transformation?
What is a repository? And how to add it in an informatica client?
Can you generate sequence numbers without using the sequence generator transformation?
