Interested to Buy Any Domain ? << Click Here >> for more details...
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
- 6 Answers
- 11832 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / satish
Using REG_MATCH function we can check string....
Expersion trx create variable port FLAG = IIF(REG_MATCH(COL_NAME , [a-zA-Z]+,TRUE,FALSE)
router trx create port nd give condition FLAG=TRUE-------------connect to string target
Default group -----------------------------conn to( number,special char) trg
SQ-EXP-RTR-TRG
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
During the running session, output files are created by informatica server. Enlist few of them.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain load alternative records / rows into multiple targets - informatica
What do you mean incremental aggregation?
what is unit testing?tell me proceedure
What is the difference between a repository server and a powerhouse?
what is degenerated dimension?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Clarify the utilization of aggregator cache record?
What are the types of data warehouses?
How to create or import flat file definition in to the warehouse designer?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to use procedural logic inside infromatica?
