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....
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 |
Explain direct and indirect flat file loading (source file type) - informatica
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
why normalizer transformation can not used in mapplet? plzzzz answer
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
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
what is the difference between lookupoveride and joiner?
in which situations do u go for starflake schema ?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
what is scd?
In target table how to display the system time
What is aggregate cache in aggregator transforamtion?