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
- 9924 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 |
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
Can you start a batches with in a batch?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the disadvantages of Sequence Generator T/R?
What is mapping debugger?
Teradata 
