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
- 1 Answers
- 2616 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How do you promote a non-reusable transformation to reusable transformation?
How to load a Dimension ? and how to load a fact table?
What is the meaning of decode in informatica?
How to update a particular record in target with out running whole workflow?
Briefly define reusable transformation?
What is decode in static cache?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Scheduling properties,whats the default (sequential)
What's the layout of parameter file (what does a parameter file contain?)?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Under which circumstances, informatica server creates reject files?
What is rank index in rank transformation?
Explain the types of lookup transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
