i have a table with name field. i,e name Shankar prabhakar nitik

i have a table with name field.
i,e name
Shankar
prabhakar
nitikripa so no
if a occures 3 times in name then it will go to tgt A
if b occures 3 times in name then it will go to tgt b
..
if z occures 3 times in name then it will go to tgt z

Question Posted / kuni_ankita

1 Answers
3407 Views
HCL, I also Faced
E-Mail Answers

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occ..

Answer / isha

I will write the logic for a and you can use the same logic for all 26 alphabets.

check_a=REPLACECHR(1,Name,'a', NULL) -- 1 means not case sensitive
count_a=LENGTH(NAME)-LENGTH(check_a)

in router group a count_a =3

Pass this to Target

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Informatica Interview Questions

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers

Enlist the differences between database and data warehouse.

0 Answers

1 lac of flat fles in source how to load target at a time?

4 Answers Cap Gemini,

What is sq transformation?

0 Answers

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers

Can you use one mapping to populate two tables in different schemas

2 Answers

To import the flat file definition into the designer where should the flat file be placed?

0 Answers Informatica,

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers ITC Infotech, TCS,

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers HCL,

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers TCS,

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers TCS,

For more Informatica Interview Questions Click Here