Interview Questions Answers in Informatica

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 # 14955

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 14955

Answers / { raja shekhar }

Question { 27643 }

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, 10212 }

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