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 the differences between source qualifier and joiner transformation?

602


What are connected or unconnected transformations?

630


Tell me about MD5 functions in informatica

530


How do you convert single row from source into three rows into target?

607


What can we do to improve the performance of informatica aggregator transformation?

620






How would you copy the content of one repository to another repository?

563


How to elaborate powercenter integration service?

653


What are the types of lookup transformation?

636


what is index?how it can work in informatica

1590


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1702


What are mapplets? How is it different from a Reusable Transformation?

630


What are the types of schemas we have in data warehouse.

535


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1020


my source is junk data how will u remove that junk data by using unix please any one replay me

3248


What do think which one is the better joiner or look up?

733