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
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 exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
How to load a relational source into file taget?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
What are the new features of informatica 7.1?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
How can you define user defied event?
What is a surrogate key?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What happens if the info. Server doesn't find the session parameter in the parameter file?