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
- 3445 Views
- HCL, I also Faced
- E-Mail Answers
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 |
What is difference between stored procedure transformation and external procedure transformation?
How to compare Source and Target table, without using dynamic lookup?
My source table having some records ,i want load 1st record and last record into one target?
h0w many versions have been developed of onformatica so far?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Describe the impact of several join conditions and join order in a joiner transformation?
which is better perfomancewise lookup or joiner and why?can anyone give example?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
write a query to get maximum salary from the employers table without duplicates....kindly help me
how we can update a target table without update strategy and update override?
Clarify the aggregator change?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Teradata 
