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
- 30049 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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How is union transformation utilized?
generate date / time dimension in informatica
What is a rank transform?
How to open an older version of an object in the workspace?
Is stop and abort are same in informatica?
What do you understand by term role-playing dimension?
Write the program through which the records can be updated?
Is there any way to read the ms excel datas directly into informatica?
What is data movement mode in Informatica and difference between them?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is xml source qualifier transformation in informatica?
Define joiner transformation?
how to load dimension table and fact table. plz tell me the steps.
What is powercenter on grid?
