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 IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what is the difference between informatica6.1 and infomatica7.1
What is an unconnected transformation?
Explain the mapping variable usage example in informatica
What are 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 the benefit of partitioning a session?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Enlist some properties of sessions.
What is the meaning of up gradation of repository?
Which development components of informatica have the highest usage?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is an active transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?