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...

Major difference between SQL override and Lookup Sql override

1 Answers  

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

What are the new features of informatica 7.1?

2 Answers  

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

How can the following be achieved in 1 single Informatica Mapping. * If the Header table record has error value(NULL) then those records and the corresponding child records in the SUBHEAD and DETAIL tables should also not be loaded into the target(TARGET1,TARGET 2 or TARGET3). * If the HEADER table record is valid, but the SUBHEAD or DETAIL table record has an error value (NULL) then the no data should be loaded into the target TARGET1,TARGET 2 or TARGET3. * If the HEADER table record is valid and the SUBHEAD or DETAIL table record also has valid records only then the data should be loaded into the target TARGET1,TARGET 2 and TARGET3. =================================================== HEADER COL1 COL2 COL3 COL5 COL6 1 ABC NULL NULL CITY1 2 XYZ 456 TUBE CITY2 3 GTD 564 PIN CITY3 SUBHEAD COL1 COL2 COL3 COL5 COL6 1 1001 VAL3 748 543 1 1002 VAL4 33 22 1 1003 VAL6 23 11 2 2001 AAP1 334 443 2 2002 AAP2 44 22 3 3001 RAD2 NULL 33 3 3002 RAD3 NULL 234 3 3003 RAD4 83 31 DETAIL COL1 COL2 COL3 COL5 COL6 1 D001 TXX2 748 543 1 D002 TXX3 33 22 1 D003 TXX4 23 11 2 D001 PXX2 56 224 2 D002 PXX3 666 332 ======================================================== TARGET1 2 XYZ 456 TUBE CITY2 TARGET2 2 2001 AAP1 334 443 2 2002 AAP2 44 22 TARGET3 2 D001 PXX2 56 224 2 D002 PXX3 666 332

3 Answers   IBM, Mphasis,

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,