if source is table you can use sql override select * from emp union sel

if i am having 10 records in source, i want 20 records in
target...how will you do it

Question Posted / srinivas

13 Answers
18071 Views
BirlaSoft, IBM, I also Faced
E-Mail Answers

Answer Posted / srinivas

if source is table you can use sql override
select * from emp
union
select * from emp
and if source is not a table run the session twice

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does update strategy mean, and what are the different option of it?

1034

What is data caches/ index caches?

1019

What is the use of source qualifier?

1069

How to create the source and target database connections in server manager?

1033

Describe an informatica powercenter?

1034

In informatica workflow manager, how many repositories can be created?

1267

Explain why we use partitioning the session in informatica?

1005

What are the steps involved in the migration from older version to newer version of Informatica Server?

2042

What are data-driven sessions?

1142

What are the different types of olap? Give an example?

973

what are the deliverables?in your project?

2084

What is complex mapping?

1067

what is the Default Source Option For Update Strategy Transformation?

1165

Explain the code page compatibility?

1021

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1884