What is the term PIPELINE in informatica ?
Answers were Sorted based on User's Feedback
Answer / naveen
pipeline term in informatica gives the physical flow of data
from source to target or any other transformation.
| Is This Answer Correct ? | 45 Yes | 2 No |
Answer / thava
Pipeline term in informatica means the way source is flow
to target via any transformation e.g filter transformation
| Is This Answer Correct ? | 21 Yes | 1 No |
Answer / thirumalaiah
A pipeline consists of a source qualifier and all the
transformations and targets that receive data
from that source qualifier.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / srikanth
pipeline is the collection fo sources, transformations and
targets that receive data from a single active source.
| Is This Answer Correct ? | 3 Yes | 7 No |
Answer / bsgsr
pipeline is used in the context of patitioning the source
so that the dtm process is executed i a less time. to meke
informatica server read,transform n load the data into the
targets in a relatively less duration.
| Is This Answer Correct ? | 4 Yes | 12 No |
Answer / nagendra phani
PIPELINE means source type. It might be a database or flatfile/
| Is This Answer Correct ? | 1 Yes | 12 No |
enterprise datawarehouse your project phase by phase explain?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
without dynamic lookup transformation how to insert new rows and update existing rows?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
can you use flat file for lookup table?why?
What is Index Caches size?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
What are different types of transformations available in informatica?