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
- 10486 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / rakesh
use a Sequence Generator to generate a column NUM
in Router 1st Group: MOD(NUM,3)=1
2nd Group: MOD(NUM,3)=2
3rd Group: MOD(NUM,3)=0
Im not sure about MOD format, but this idea will workout..
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What do you mean incremental aggregation?
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 do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the types of schemas we have in data warehouse.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a pre-defined event and user-defined event?
difference between informatica 8.1.1 and 8.6
Explain incremental aggregation in informatica
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Separate from an archive server and a powerhouse?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is a joiner transformation and why it is an active one?
which one is better performance wise joiner or look up
What is standalone command task?
