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
- 10812 Views
- Polaris, I also Faced
- E-Mail Answers
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 session task and command task?
If informatica has its scheduler why using third party scheduler?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are pre and post-session shell commands?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Why do we need informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
can u give example for factless fact table
What is data caches/ index caches?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How can we store previous session logs?
What are the data movement modes in informatica?
What is intricate mapping?
