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
What are the types of data warehouses?
Explain the informatica workflow?
How is union transformation utilized?
What is workflow manager?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the command used to run a batch?
Explain the types of lookup transformation?
Enlist the tasks for which source qualifier transformation is used.
During the running session, output files are created by informatica server. Enlist few of them.
How can you validate all mappings in the repository simultaneously?
What are the main features of Oracle 8i with context to datawarehouse?
Explain informatica architecture - version 8 / 9
What is substr in informatica?
without table how to come first record only in oracle?
Explain lookup transformation in informatica