how to design mapping half of source table records into one
target and remaining half into another target
Answer Posted / sbvp
hi raj
when we use source as a flat file
if a flat file contians 10 records assume ok
take seq gen t/r- next val
to exp t/r
in that add a new port and give seq gen-nextval to that new
port(suppose call as seq_num ok)
take RTR t/r
create two out ports ok
seq_num<=5
seq_num>=5
contect to two tgrts ok
thanks
sbvp
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the benefit of session partitioning?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the types of presistent cache in look up tr.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
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 maplet?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is source qualifier transformation in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Write the advantages of partitioning a session?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the types of caches in lookup?
How to open an older version of an object in the workspace?
Explain about cumulative Sum or moving sum?