Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?

Answer Posted / ankit kansal

It can be one of the solution
tgt table contains two columns

src->sq->exp1-->>tgt(1) one instance of tgt table.
---------exp2-->>tgt(2) second instance of tgt table.

*after sq forward c1 and c2 to exp1
and c1 and c3 to exp2

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an expression transformation in informatica?

1092


What are the settings that you use to configure the joiner transformation?

1104


Clarify the utilization of aggregator cache record?

1045


How you can differentiate between connected lookup and unconnected lookup?

1106


What is an unconnected transformation?

1131


What is joiner change?

1194


What is the way to execute pl/sql script using informatica mapping?

1681


How to do unit testing in informatica?

1229


Explain the mapping variable usage example in informatica

1224


How can you validate all mappings in the repository simultaneously?

1426


Different circumstance which drives informatica server to expel records?

1043


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282


Enlist few areas or real-time situations where informatica is required.

1139


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2107