hi, hi can anybody answer my query... that is i had a source table containing for eg;D1,D2,D3,D4,D5 one by one that means in a each column contains single source i.e., D1 in 1st col,D2 in 2nd col so on now i want in my target like D1-D2 in one col, D1-D2_D3 in other col,D2_D3-D4 in other col and D3-D4-D5 in other col plz send as soon as possible.......... thanx in advance

Ashish

• Jul 23rd, 2011

Use expression transformation to get the desired output

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

One can pass the input through the expression, where the variable/output ports can be configured to pass the combined value by using the CONCATENATION function of informatica.

Answer Question  Select Best Answer

Rambabu

• Jan 17th, 2012

Yes we can do it

Shravani

• Jan 13th, 2012

Yes we can.

Answer Question  Select Best Answer

sriinivas kasiboina

• Feb 15th, 2012

SCD Type 3 is used when it is necessary for datawarehouse to keep track of historical changes and when such changes will only for finite number of times.

sriram

• Sep 27th, 2011

Scd type3 is used for loading the current & most previous data into target

Answer Question  Select Best Answer