How can i send first half of the records to one target and
Remaining to other target?
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
Define filter transformation?
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 a passive transformation?
How to join three sources using joiner? Explain though mapping flow.
What are the databases that informatica can connect to windows?
What are the different transaction levels available in transaction control transformation?
What are the tasks that source qualifier perform?
How can we store previous session logs?
How many types of sessions are there in informatica.please explain them?
How can we use mapping variables in informatica? Where do we use them?
Different qualification between a related rotate toward the sky and isolates look upward?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the main features of Oracle 8i with context to datawarehouse?
what is Active lock explain
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.