HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?

Answer Posted / satya

I dont agree with Ojesh, how do get the value from unix and
store it in variable.

Use a seq.gen t/m and write from SQ and SQE.GEN to Aggr
T/M. find the count and in the router use expressions
1. <= total_count/2
2. > total_count/2


for more details get in touch with me at satya.ylv@gmail.com

-Satya

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain informatica architecture - version 8 / 9

665


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1247


what is degenerated dimension?

3148


What are ETL Tools?

664


r u done any partitions in ur project?

1402






what is index?how it can work in informatica

1578


Enterprise data warehouse your projects phase by phase explain?

1458


What are the reusable transformations?

694


Explain the different kinds of facts.

560


What are mapplets?

814


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1513


What is source qualifier transformation in informatica?

571


What are the various types of transformation?

640


Explain lookup transformation in informatica

642


How many numbers of sessions can one group in batches?

616