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
- 2633 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
what is the size of u r source(like file or table)?
Reusable transformation and shortcut differences
What is the need of etl tools?
What is informatica?
How to call shell scripts from informatica?
Explain in detail scd type 2 through mapping.
What are the differences between a connected lookup and unconnected lookup?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is data transformation manager process?
What are batches?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Is it possible to create multiple domains on a single Informatica server?
Enterprise data warehouse your projects phase by phase explain?
Mention few advantages of router transformation over filter transformation.
