1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / swarna.latha165

Answers were Sorted based on User's Feedback



My source is flat file which contain only one column with data type varchar.now i want to send strin..

Answer / vijaya

By using function isnumber(), is string() in expression editot you get the solution

Is This Answer Correct ?    6 Yes 4 No

My source is flat file which contain only one column with data type varchar.now i want to send strin..

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

My source is flat file which contain only one column with data type varchar.now i want to send strin..

Answer / kamlesh mishra

Use is_number(field) and not is_number(field) functions in router transformations

Is This Answer Correct ?    0 Yes 0 No

My source is flat file which contain only one column with data type varchar.now i want to send strin..

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

My source is flat file which contain only one column with data type varchar.now i want to send strin..

Answer / davan

In expresion t/r just give data type as string only...

Is This Answer Correct ?    0 Yes 4 No

My source is flat file which contain only one column with data type varchar.now i want to send strin..

Answer / swarna.latha165

please tell me the solution

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More Informatica Interview Questions

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

What is an Integration service in Informatica?

0 Answers  

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

What are the different types of olap? Give an example?

0 Answers  




1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

Differentiate between mapping parameter and mapping variable?

1 Answers  

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

why we need informatica

2 Answers   HCL,

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

How can we create index after completion of load process?

0 Answers  

For more Informatica Interview Questions Click Here
Categories