i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.
Answer Posted / vivek ranjan
I Think that you run the queary
select * from tablename where unique_no = 0 and unique_no =
5.
Definitally you featch 1 and 5 record every time when you
execute queary.
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
Explain your project of banking domian.
How do you convert single row from source into three rows into target?
What is data transformation manager process?
What is the reusable transformation?
Differentiate between joiner and lookup transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain the features of connected and unconnected lookup.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the tuning lookup transformation - informatica
have u done any performance tuning? how u ll do?
Enlist the differences between database and data warehouse.
How does a sorter cache works?
What is an aggregator transformation?
how we can load rejected record's at run time?(not through bad files)
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?