it's just like a simple pass.But we have to use an expresion in betw

i have 1000 records in my dource table, the same i have in
target ,but a new column added in target as "batchno", and
this column adds no 10 for 1st 100 records and 20 for next
100 records and 30 next 100 records and vice versa. how to
acheive this?

Question Posted / rajkumar

6 Answers
11643 Views
Thomson Reuters, I also Faced
E-Mail Answers

Answer Posted / rajkumar

it's just like a simple pass.But we have to use an
expresion in between source and target we have to continue
the loop of variable port has to continue for every 100
records.

Is This Answer Correct ?

1 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the conditions needed to improve the performance of informatica aggregator transformation?

1034

define galaxy repository in informatica

2154

How can we delete duplicate rows from flat files?

1162

How to Create a folder using pmrep command?

1104

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?

1442

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1267

Explian the Process of deployment groups in informatica

990

Define enterprise data warehousing?

1129

What are the main issues while working with flat files as source and as targets ?

1096

What is a predefined event?

1032

What are the new features of informatica 9.x in developer level?

937

What is workflow? What are the components of workflow manager?

1119

Where are the source flat files kept before running the session?

1010

Which are the different editions of informatica powercenter that are available?

971

What is the use of transformation?

945