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 |
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
How to import oracle sequence into Informatica?
Can we use parameters of parameter file in presession command
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
what r the transformations that r not involved in mapplet?
What are the associated ports in look up T/R.
Difference Between ETL & ELT?
have you developed documents in your project? and what documents we develop in realtime?
what is SDLC way of code development?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?