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...

My source is delimited flat file Flat file data is H|Date
D1|ravi|bangalore D2|raju|pune T|4 The data will be send to
target if the fallowing two conditions satisfied 1.The first
row Date column is equal to SYSDATE 2.Last record second
port equal to number of records. How to achieve?

Answer Posted / krish

first flow sq to agg (in agg do count(d1))name it as Y

take a another flow send that to aggg u will get the last
record of the second column name it as some X


send the two flows to router give the condition as that
date column as sysdate and X=Y

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1129


Explain the types of transformations?

1104


What are the advantages of using informatica as an etl tool over teradata?

1077


Where can we find the throughput option in informatica?

1107


Explain the informatica workflow?

1127


scenario where i can use only concurrent execution of workflow.

3262


What do you mean incremental aggregation?

1131


what is the difference between informatica6.1 and infomatica7.1

2362


What is the use of an aggregator cache file?

1249


Describe data concatenation?

1126


Can we create a Integration service without a Repository service and vice versa?

1260


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

1183


Write the program through which the records can be updated?

1055


What are multi-group transformations?

1165


How to extract sap data using informatica? What is abap? What are idocs?

1253