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
- 10298 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 |
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
What is difference macros and prompts?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Explain the flow of data in Iinformatica?
How many repositories can we create in Informatica??
What is the Rank index port in Rank transformation?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain pushdown optimization and types in informatica
in which situations do u go for starflake schema ?
What are the new features of informatica 9.x developer?
Teradata 
