Interested to Buy Any Domain ? << Click Here >> for more details...
Hello Everyone,i have one question on sequence generator.i
have two targets and the records comes from the source will
place in the targets like 1-10 rec in target1 and 11-20 rec
in target2,21-30 rec in target1...etc so any one can help
me? plz..Thanq in adv.
- 7 Answers
- 15329 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ahalyabest@gmail.com
SQ---> SEQ GEN---> EXP--> ROUTER---> TRG1, TRG2, TRG3, TRG4
in seq generator properties
start value-1
increment value-1
end value-4
current value-1
cycle-true
reset-true
in router conditions
4 conditions
group 1= iif ((nextval=1)1,0)
group 2=iif (( nextval=2)1,0)
group 3=iif((nextval=3)1,0)
group 4=iif((nextval=4)1,0)
connect
group1-->target1
group2-->target2
group3-->target3
group4-->target4
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what are the deliverables?in your project?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
is it possible to index the data in cache of lkp transformation ?
what is unit testing?tell me proceedure
What is fact table? Explain the different kinds of facts.
What is the need of etl tools?
Differentiate between Load Manager and DTM?
what is the size of your data warehousing?
What is deployment group?
How are indexes created after completing the load process?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How can we handle two sessions in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
