Question { TCS, 13238 }

S1 is having 1 lakh records and s2 is having 100 records,
s2 should compare s1 if emp no is same data should be
updated if not their it should insert the data.what are the
transformation used?

Answer

I go with Naveen's solution with a small change. I would
replace filter with Router TRFM.

Question { HCL, 9772 }

Insert else update option in which situation we will use

Answer

We set this property when the lookup TRFM uses dynamic
cache and the session preperty TREAT SOURCE ROWS
AS "Insert" has been set.

Question { CTS, 12126 }

How will you update the row without using update statergy?

Answer

you can use SQL transformation

Question { IBM, 10164 }

I am having a FLAT FILE SOURCE as first line:
1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
null,null,null,4000 ............................Now i want
the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For
more clarification i
want to elimate nulls and want in a single line. Please
help me out

Answer

FF ---> SOURCE QUALIFIER ---> EXPRESSION ---> AGGREGATOR ---
>TARGET FILE

In Expression TRFM,
a) for each column, create an expr to replace null values
with 0.
IIF(ISNULL(port_name),0,port_name)
b) create an output port (dummy_col) and set its value to 1

In Aggregator TRFM
a) Group by the dummy_col
b) for each of the 4 columsn, find the max value

Question { HP, 7387 }

i have source like
X1 10
X2 20
X1 30
X2 40

i want target as
X1 X2
10 20
30 40 in informatica

Answer

SOURCE--->SOURCE QUALIFIER ----> EXPTRANS1 -----> FILTER ---
--> EXPTRANS2 ------> TARGET

In EXPTRANS1, concatenate X1 and X2 values for every 2nd
record (ie X= X2). Lets call this output column as
x1x2_value
Note: I am concatenating for every second record as X1 and
X2 appear alternatively In your sample data,

In the filter transformation, have the filter condition
X='X2' (only these recs have the concatenated data)

In EXPTRANS2, Using substr to split the data into X1 and X2
and load it into target table