Interested to Buy Any Domain ? << Click Here >> for more details...
suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
- 9 Answers
- 13037 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shankar
SQ---->AGR---->RTR---->TGT
SEQ--->RTR
1) Pass all records to Agr
In AGR take count port ion taht give count(empno)
2)Next create SEQQUENCE GENERATOR connect nexval to router
3) Int RTR Create one Group called 1st half
In that give nextval<=count/2
4) Connect to TGTs from 2 groups (1st half and Default)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a stored procedure transformation?
What are the new features of informatica 9.x in developer level?
how to load dimension table and fact table. plz tell me the steps.
State the limitations where we cannot use joiner in the mapping pipeline?
Different qualification between a related rotate toward the sky and isolates look upward?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Why update strategy and union transformations are active?
Mention a few design and development best practices for informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
How an expression transformation differs from aggregator transformation?
How are indexes created after completing the load process?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
how many types of dimensions are available in informatica?
What is target designer and target load order?
