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

What does command task mean?

1215

State the differences between sql override and lookup override?

1283

How do you handle two sessions in Informatica

1217

Explain pushdown optimization and types in informatica

1122

What are the differences between joiner transformation and source qualifier transformation?

1235

What is a router transformation?

1212

What is sorter transformation?

1108

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2510

What is informatica?

1218

Explain sessions. Explain how batches are used to combine executions?

1077

What is dimensional table? Explain the different dimensions.

1245

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5786

How would you join a node to the already existing domain?

1180

How to implement security measures using repository manager?

1233

Can we change Dynamic to Static or Persistent cache? If so what happens?

2248