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
- 10090 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 |
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
what happens if you try to create a shortcut to a non- shared folder?
In dimension and fact table? which one holds big data?
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
Could any one to tell How to use the Oracle Analytic functions in Informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
How will you update the first four rows and insert next four rows in a mapping?
What all are steps in up gradation of Informatica server?
What is the benefit of session partitioning?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
Teradata 
