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
- 3492 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 parallel processing in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
can v update d records in target using update stargey without generationg primary key ? explain
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
What will be the approach?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
which is better perfomancewise lookup or joiner and why?can anyone give example?
Teradata 
