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
- 3628 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 |
Is it possible to update the target table with PK?
What is difference between Mapplet and reusable transformation?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
how to join the 2 different table with different columns in informatica?
Do you have to change the reject file b4 using reject loader utility.
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
How to generate sequence numbers without using the sequence generator transformation?
What are the different components of powercenter?
What is the difference between lookup override and souce qualifier override ?
Teradata 
