suneel kumar


{ City } hyderabad
< Country > india
* Profession * student
User No # 54859
Total Questions Posted # 0
Total Answers Posted # 3

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 13
Users Marked my Answers as Wrong # 5
Questions / { suneel kumar }
Questions Answers Category Views Company eMail




Answers / { suneel kumar }

Question { IBM, 12373 }

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

Simple.Take arithematic calculation, record divisible by five if result is zero then pass it where u want,for first record pass it directly.It's c logic man.i gave one idea that much only.

Is This Answer Correct ?    0 Yes 3 No

Question { TCS, 6724 }

How to Join Tables my Source is having 15 table target is
one?


Answer

First of all which type of sources yiu are using.
1)If all source types are same type of databases you can go
for joiner or SQ
2)If sources are diff types of databases u should go for joiner.

Is This Answer Correct ?    6 Yes 1 No


Question { IBM, 8081 }

what is the query for retrieve the unique values(not display
the duplicates values) from single table?


Answer

Select distinct from tablename

Is This Answer Correct ?    7 Yes 1 No