How can i send first half of the records to one target and
Remaining to other target?
- 10 Answers
- 26905 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / venu
s----sq------srt----rtr---t1
t2
inthis flow take two sequence generaters and connect to
s0rter t/f like this
nextvalue descending order enable
nextvalue1 asending order enable
for example if 6 records contain
the sort result would be
nextvalue nextvalue1
6 1
5 2
4 3
3 4
2 5
1 6
sorter contain these ports and remaing ports next pass these
ports to ruter t/f
nextvalue > nextvalue1 1st condition ---it give 1st 3rows
nextvalue < nextvalue1 2nd cond ---- it gives last 3 rows
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is a repository? And how to add it in an informatica client?
What are the limitations of joiner transformation?
What is workflow? What are the components of the workflow manager?
How to start a workflow using pmcmd command?
How to join three sources using joiner? Explain though mapping flow.
How many ways a relational source definition can be updated and what are they?
How to generate sequence numbers?
Differentiate between a database and data warehouse?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a shortcut and copy in Informatica and how two are different with each other?
How many transformations can be used in mapplets.
On which transformations you created partitions in your project?
What is the difference between stop and abort in informatica
While migrating the data from one environment to another environment how would you manage the connections?
