Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3529 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 load unique records into one target table and duplicate records into a different target table?
What are the new features of informatica 9.x developer?
How do you set a varible in incremental aggregation
Write the unconnected lookup syntax?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can you use flat files in Mapplets.
What does update strategy mean, and what are the different option of it?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is meant by lookup transformation? Explain the types of lookup transformation?
Why filter transformation is an active one?
Define filter transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
