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

If a table contains 100 records we have to fetch 50-100
records from source to target?how

Answer Posted / tauseef

hai Tauseef,

as per my knowledge we can Fetch 50-100 records
by using rownum>=50 in source qualifier it self after generation sql query

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1604


How do you change a non-reusable transformation to reusable transformation?

942


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1195


How do you convert single row from source into three rows into target?

1091


What is parallel processing in informatica?

1619


What is confirmed fact in dataware housing?

6801


define galaxy repository in informatica

2155


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1047


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2179


What is meant by pre and post session shell command?

1104


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

2182


Did u used latest transformations of 8.6.0? for what?

1823


what is the -ve test case in your project.

2329


What is union transformation?

907


what is mean by complex business rule ?

2109