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
- 3411 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
EXL informatica Questions
What are junk dimensions?
How will the document be delivered to me?
What are the measure objects?
What all are steps in up gradation of Informatica server?
design of staging area?
What do you mean by filter transformation?
Explain load alternative records / rows into multiple targets - informatica
Is it possible to define a single node as a Gateway node as well as worker node?
What are the uses of etl tools?
what is the hint? how to use it to reduce the query processing in program?
What is the need of an ETL tool?
Explain the shared cache and re-cache?
Explain the aggregator transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
