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

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?

Question Posted / ankur saini

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

Please Help Members By Posting Answers For Below Questions

Explain the difference between a data warehouse and a data mart?

1000

What are the different clients of powercenter?

1006

What is the surrogate key?

1148

What is an expression transformation?

968

What are the various types of transformation?

1094

How we can use union transformation?

989

In which transformation you cannot drag ports into it?

1243

What are the data movement modes in informatica?

1081

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

1015

What are the transformations that are not supported in mapplet?

956

While migrating the data from one environment to another environment how would you manage the connections?

1047

Differentiate between sessions and batches?

963

Global and Local shortcuts. Advantages.

1957

is it possible to index the data in cache of lkp transformation ?

1959

What is the sql query overwrite in source qualifier in informatica

1026