Hi please try to reply with answer. my mail id is
raghu.1028@gmail.com.
if the source is having millions of records, but having
theree target tables. As per user the first record need to
insert into first target and second record in to a second
target and third into third target, similarly the process
needs to repeat?
Answer Posted / srinivas
sequence generator>expression trans>router>targets
in router create 2 userdefined groups, 1 default group.
ie total 3 o/p groups
group1 condtion . mod(nextval,3)=0
group2 condtion . mod(nextval,3)=1
group3 condtion . mod(nextval,3)=2
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
how would u estimate the size of Aggregator transform data and index cache?
flat filevalidation in informatica
Two default user groups created in the repository are____and_____.
explain the methodology of Data Warehousing?(Polaries)
what are the facilities provided by data warehouse to analytical users?
What is meant by incremental load?
What do you understand by active and passive transformations?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
can cubes contain measures ?
how do u set partition points in the mapping?
What is tracing level? How many types of transformations supported by sorted input?
Explain about power designer data modeling software?
how do u really know that paging to disk is happening while u are using a lookup transform?
State the differences between shortcut and reusable transformation