Answer / vinithra

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.

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 .

Answer / n.bandaru

Yes, I agree above answers.

Answer / amedela chandra sekhar

above source qualifier upstream transformation and
expression is down stream transformation

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.

Answer / rashmi garg

hi Vinithra, you are absolutely right :)

Answer / abc

please somebody reply...

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

where is the reject loader .

1 Answers  

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

What is a mapplet/worklet in informatica?

0 Answers  

which transformation uses cache?

3 Answers   Keane India Ltd,

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,