what is upstream and downstream transformation?
Answers were Sorted based on User's Feedback
Hi,
Say a Transformation1 accepts input from transformation 2
and passes the output to a transformation 3 , then
transformation 2 is called an upstream transformation.
transformation 3 is called a downstream transformation.
I got this from INFA Help.Please let me know if im wrong!
Thanks.
| Is This Answer Correct ? | 24 Yes | 4 No |
Answer / prabha
Yes...suppose you have a mapping in that u hv source 1 then
expression transformation then the target..then this
sequence will be called a pipeline and source will be the
upstream transformatation and target will be downstream
transformation for that expression transformation .
| Is This Answer Correct ? | 23 Yes | 3 No |
Answer / amedela chandra sekhar
above source qualifier upstream transformation and
expression is down stream transformation
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / czarabid
In very simple terms "From any repo when we transfer the
data/bits then this repo will be called as upstream,
To any repo when we transfer the data/bit then this repo
will be called as downstream"
For instance consider SVN/GIT when we check in the source
code from it then it becomes downstream and when we make
changes to source code and check out then it is called as
upstream.
| Is This Answer Correct ? | 1 Yes | 0 No |
How many cubes create from a single model?
waht type of interface is used for testing the data in informatica
Briefly define reusable transformation?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
How can you run a session without using server manager?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
How can we eliminate duplicate rows from flatfile,explain?
What is substr in informatica?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
How to generate the HTML output using Informatica.
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
 Informatica Checkpoints