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
- 9849 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
In informatica workflow manager, how many repositories can be created?
Define joiner transformation?
How can we remove the duplicates from flat file source?
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.
Which is the t/r that builts only single cache memory?
How to partition the Session?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How many transformations can be used in mapplets.
Is it possible to use a client with different version than that of its Informatica server?
Explain Dataware house architecture .how data flow from intial to end?
What do mean by local and global repository?
How do you change a non-reusable transformation to reusable transformation?
