Interested to Buy Any Domain ? << Click Here >> for more details...
following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
- 7 Answers
- 10811 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / venkat
->Connect desired columns to Expression and create custom
colum.
->Use Sequence Gen inorder to generate cyclic values 1,2,3
logic :start with 1 ,increment by 1 and end with 3
Cycle -Yes.
->Connect it to Custom column
->Use Router to rout coresponding group
Group1 -Value1- Target1
Group2 -Value2- Target2
Default-Value3- Target3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the types of lookup transformation?
Enlist some properties of sessions.
What is the cumulative sum and moving sum?
Explain the difference between a data warehouse and a data mart?
expain about the tune parameters?
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
What is informatica? Why do we need it?
How to create or import flat file definition in to the warehouse designer?
how tokens will generate?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Differences between version 7.x and 8.x.
What are the databases that informatica can connect to windows?
tell me 5 session failure in real time how can you solve that in your project?
How do you load first and last records into target table?
Does an informatica transformation support only aggregate expressions?
