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
- 10037 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
what are the deliverables?in your project?
Is it possible to create multiple domains on a single Informatica server?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How can you differentiate between powercenter and power map?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
4 yrs etl devloper roles and responsibilities?any body give solutions
Why filter transformation is an active one?
How to generate sequence numbers using expression transformation?
What is the difference between a repository server and a powerhouse?
What is lookup transformation?
What does cheating measurement mean?
Performance tuning in UNIX for informatica mappings?
Explain the tuning lookup transformation - informatica
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
