Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10051 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 |
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
When we are using Dynamic Cache,which options we will select in session level?
Which kind of index is preferred in DWH?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
What is batch and describe about types of batches?
how can we perform incremental aggregation?explain with example?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
Does an informatica transformation support only aggregate expressions?
How does the aggregator transformation handle null values?
in which situations do u go for starflake schema ?
what is threshold error in informatica?
What is surrogate key?
Teradata 
