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
- 11616 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijaya
By using function isnumber(), is string() in expression editot you get the solution
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / santosh kumar sarangi
1.in expression t/r create one more port as below.
FLAG(integer)=IIF(LOWER(COL1)=UPPER(COL1) ,1,0)
2.Link the original port and FLAG port to router and create
a group as FLAG=1
3.Link the original port from the group to target of number
or special charater and default to target of character.
Let me know if any things wrong
Thanks and Regards
Santosh
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kamlesh mishra
Use is_number(field) and not is_number(field) functions in router transformations
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / davan
In expresion t/r just give data type as string only...
| Is This Answer Correct ? | 0 Yes | 4 No |
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
create a mapping to retrieve the employees who are getting salary greater than average salary?
What are Target Options on the Servers?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
what is a time dimension? give an example?
what is degenerated dimension
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
If we are using an aggregator but forget to mention the group by port .what will be the output??
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Teradata 
