i have 1000 record flat file source i want 1st row to 1st
target, 2nd row to 2nd target, 3rd row to 3rd target how will
u do? Without using Mod Function? Explain....
- 4 Answers
- 8613 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mithilesh kumar rai
step 1. Pass the value from Source Qualifier to Expression.
step 2. Take a Sequence Generator and Enable the Option
Reset and set endvalue=3 , (take Sequence generator
before expression and pass value nextval of SG to Exp.
step3. after Exp, take router in router make 3 group
1st Group: Nextval=1
2nd Group: Nextval=2
3rd Group: Nextval=3
Step 4: Pass the value to Target.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / davankumar
1st take squence t/t conn expresion t/r to one out put port.
In sequence t/r enable cycle option and start value is 1
end value is 3 and increment by 1.
then take rouder t/r in 1st group nextval/3=0 then 1st
target,nextval/3=1 then take 2nd target then connect to
default group ok.. r u clear...
| Is This Answer Correct ? | 11 Yes | 1 No |
simple before targets put the sequence generator t/f enable cycle option put start value 1 and end vale 3 connect to all three target
| Is This Answer Correct ? | 0 Yes | 1 No |
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
how many session run unix environment what command using ?
Limitation of REPLACESTR. Is there any character limitation to it.
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How we can use union transformation?
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
Teradata 
