1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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


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

What are partitions in informatica and which one is used for better performance?

2 Answers  

What are conformed dimensions?

1 Answers  

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,




What is update override?

1 Answers   Accenture,

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

how many session run unix environment what command using ?

1 Answers   HCL,

When do you use mapping parameters? (In which transformations)

1 Answers  

Explain the flow of data in Iinformatica?

1 Answers  

For more Informatica Interview Questions Click Here
Categories