Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source with 100 records.i have 2 targets.in the first
target i want to load first 50 records & in the second target
i want to load next 50(or remaining) records.
- 3 Answers
- 7810 Views
- I also Faced
- E-Mail Answers
Answer Posted / mukunda
Mapping structure
=================
source-->sq-->sequence-->exp-->router-->target1
|-->target2
1)Pass the seq genarator "nextval" port to expression.
2)through expression t/r pass the variable port to router
3)In router create two groups
Group1:nexval<=50-->this group conneted to target1
Groutp2:nexval>=50-->this group conneted to target2
or
default group connected to target2
Note: This logic only that source data contain 100 records.
If you any quires please ask.
Best Regards,
Mukunda
mukunda.velluri@gmail.com
| Is This Answer Correct ? | 6 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 would you join a node to the already existing domain?
How union transformation is used?
what is unit testing?tell me proceedure
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to update or delete the rows in a target, which do not have key fields?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
pmscmd startworkflow -sv
What is joiner transformation in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
4 yrs etl devloper roles and responsibilities?any body give solutions
Define update strategy?
What is a repository? And how to add it in an informatica client?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
