raja shekhar


{ City } hyderabad
< Country > india
* Profession *
User No # 51040
Total Questions Posted # 1
Total Answers Posted # 2

Total Answers Posted for My Questions # 10
Total Views for My Questions # 12378

Users Marked my Answers as Correct # 32
Users Marked my Answers as Wrong # 4
Questions / { raja shekhar }
Questions Answers Category Views Company eMail

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.

Emirates, IBM,

10 Informatica 12378



Answers / { raja shekhar }

Question { 26383 }

what is rank and dense rank in informatica with any
examples and give sql query for this both ranks


Answer

for eg: the file contains the records with coulmn
100
200(repeated rows)
200
300
400
500
the rank function gives output as
1
2
2
4
5
6
and dense rank gives
1
2
2
3
4
5

Is This Answer Correct ?    32 Yes 4 No

Question { TCS, 8848 }

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c
i want output as 1 a,b,c and 2 a,b,c ...
how can achieve this


Answer

can u just explain in detail the concatenation part.

Is This Answer Correct ?    0 Yes 0 No