Interested to Buy Any Domain ? << Click Here >> for more details...
My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
- 7 Answers
- 10276 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
HI ,I think there is no need of sequence generator .
sq->exp->tg1
->tg2
In exp take 2 port
out_1=input_port*10
out_2=input_(port*10)+1.
Link out_1 to tgt1
Link out_2 to tgt2.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / sufi
Use Router and make two groups with the below conditions :
Group1 Condition : Mod ( Col, 10) = 0
Group2 Condition : Mod ( Col, 10) = 1
So first Group will allow data like 10,20,30,40.....
and 2nd group will allow 11,21,31,41,51.....
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / rahul
source>sq>exp>trg_1
>trg_2
take 2 seq gen
1)seq1 tnx n set properties
start_value=10
increment_by=10
end_value=110
current_value=10
cycle enable
reset enable
connect nextval to target1
2)seq2 tnx n set properties
start_value=11
increment_by=10
end_value=110
current_value=11
cycle enable
reset enable
connect nextval to target2
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / sufi
Use router with two groups with the below conditions:
Group1 condition : Mod( Col, 10) = 0
Group2 condition : Mod ( Col, 10) = 1
Group1 will allow data like 10,20,30,40....
Group2 will allow data like 11,21,31,41....
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / abhinaw prakash
The other approach would be to concatenate the incoming values with '0' and '1' in expression variable port and move it to different targets using Router.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / firdaus
src-->exp1-->target1
src-->exp2-->target2
In exp1 drag i/p port,then take o/p port
0/p=i/p||0
In exp2 drag i/p port,then take o/p port
0/p=i/p||1
thn link o/p ports of exp1 & exp2 to target1 & target2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / punitha
sr=>sq=>sq=>router=>target
in sequence generator,end value=10
enable cycle option, in router first condition nextvalue=1
another condition next value=10 ,take two targets for two onditions
| Is This Answer Correct ? | 0 Yes | 3 No |
what is SDLC way of code development?
What is the difference between view and materialised view?
How to generate the HTML output using Informatica.
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What are the types of maping in Getting Started Wizard?
what is the significance of newlookup port in dynamic look up
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
What is Java Transformation? what are the uses of it?
Explain load alternative records / rows into multiple targets - informatica
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
What is the procedure for creating independent data marts from informatica 7.1?
Teradata 
