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?
Answer Posted / triveni
startvalue=1
endvalue=3
cycle=yes seequencegenerator
\
source->sq->expression->router->target1
->target2
expression->copy nextval port to expression
router->mod(seq,3)=1
mod(seq,3)=2
mod(seq,3)=0
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Enlist the various types of transformations.
Is it possible to use a client with different version than that of its Informatica server?
What is a pre-defined event and user-defined event?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is decode in static cache?
Enlist the differences between database and data warehouse.
How many transformations can be used in mapplets.
Why update strategy and union transformations are active? Explain with examples.
Write the different tools in the workflow manager?
Explain the mapping variable usage example in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
what is the size of u r source(like file or table)?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How can you differentiate between powercenter and power map?
What is a transaction control transformation?