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 Flat file
Input is
A
B
C
I need output like this
A
A
A
B
B
B
C
C
C. How will u achieve this?

Answer Posted / ankur saini

to make this simple from sq--take 3 expressions---add union
to take data from theses three expressions

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are data-driven sessions?

1193


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2718


Describe data concatenation?

1074


What is the commit type if you have a transaction control transformation in the mapping?

1030


What are the differences between a connected lookup and unconnected lookup?

1068


What is the advantage of informatica?

1065


What is dynamic cache?

1030


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688


How big was your fact table

1797


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2177


If informatica has its scheduler why using third party scheduler?

1259


What is enterprise data warehousing?

1045


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1506


Can we create multiple integration service on single repository?

1187


What is the difference between a repository server and a powerhouse?

1503