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?
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
Can you generate sequence numbers without using the sequence generator transformation?
How can you validate all mappings in the repository simultaneously?
How to use pmcmd utility command?
what is mean by complex business rule ?
Explain the types of transformations?
In informatics server which files are created during the session rums?
write a query to retrieve the latest records from the table sorted by version(scd)
What is meant by a domain?
difference between informatica 8.1.1 and 8.6
What is the maplet?
How do you convert single row from source into three rows into target?
Explain the features of connected and unconnected lookup.
How to configure mapping in informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the types of lookup transformation?