Question { 10795 }

how do u move the code from development to production?

Answer

Using Depolyment group, We can migrate the mappings from
one repository to another repository.

Question { 8554 }

How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).

Answer

You can handed this issue, using expression transformation.

1) create one variable port and declare it as Integer and
assign the value to Output port.

e.g: var_count Integer var_count+1
out_count Integer var_count

Question { Wipro, 9262 }

source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

Answer

SQ-->SRT-->EXP-->AGG-->TGT

In SRT:
sort the record by col1 (Ascending)

In Exp:
col1
col2

v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_maxcount=iif(v_col1=col1,v_maxcount+1,1)
v_col1=col1
o_col1=v_col1
o_col2=v_col2
o_maxcount=v_maxcount

In AGG:
Group by o_col1
MAX(o_maxcount)

Question { CTS, 12143 }

How will you update the row without using update statergy?

Answer

1) If the target table doesn't have primary key, then using
update override we can update the records.

2) If target table have primary key, then we have option
called update else insert in session properties. Based upon
that we will update the records.