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
- 3488 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
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How can we handle two sessions in informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Where are the source flat files kept before running the session?
where to store informatica rejected data? How to extract the informatica rejected data?
What is a router transformation?
Is stop and abort are same in informatica?
What is mapplet in informatica?
Which is the t/r that builts only single cache memory?
How an expression transformation differs from aggregator transformation?
What are the different types of repositories created using informatica?
Mention a few design and development best practices for informatica?
What is native users?
What do you understand by a term domain?
What do you understand by term role-playing dimension?
