Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Flat file heaving 1 lack records and I want to push 52000
records to the target?

Answer Posted / tadikonda

IF IT IS A FILE

Take one variable with the name $$count at mapping variable
level
Mention the initial value for that $$count=0(For every
record it will increment the count value by 1)


source-sq-Expression-Filter-Target

in that expression just take one o/p port in that
o_count=SetCountVariable($$Count)

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2371


Explain sql transformation in script mode examples in informatica

1211


Is there any way to read the ms excel datas directly into informatica?

1070


Explain the scenario which compels informatica server to reject files?

1209


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2404


Why update strategy and union transformations are active?

1098


What is meant by pre and post session shell command?

1202


Differences between version 7.x and 8.x.

1941


Describe the impact of several join conditions and join order in a joiner transformation?

1116


What is incremental aggregation?

1137


How do you set a varible in incremental aggregation

1945


How do you load only null records into target?

1254


What is target load order?

1302


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1213


How can we create index after completion of load process?

1166