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 best practices to extract data from flat file source which are bigger than 100 mb memory?
What is data transformation manager process?
How to load a Dimension ? and how to load a fact table?
What is target load order?
difference between informatica 8.1.1 and 8.6
Explain lookup transformation source types in informatica
Explain lookup transformation in informatica
What is the use of target designer?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are some examples of informatica etl programs?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How do you update the records with or without using update strategy?
What is informatica metadata and where is it stored?
Explain incremental aggregation in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab