Answer / abhishek guddu

In Expression t/f
flag--
iif(is_number(id),to_integer(id),to_char(id))

Answer / abhishek kumar

IN EXPRESSION
FLAG->OUTPUTPORT
IIF(IS_NUMBER(ID),1,0)
IN FILTER
CONDITION
FLAG=1 (RETURN NUMERIC )
OR FLAG=0 IT WILL RETUN ALPHABETIC CHARACTER

SECOND WAY
IS WE USE ASCII() FUNCTION
ASCII(ID)>64 IT RETURN ALPHABET
ASCII(ID)<64 IT RETURN NUMBER

THANKS
ABHISHEK GUDDU

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

How can a transformation be made reusable?

0 Answers   Informatica,

---

what is mystery dimension?

1 Answers  

---

What is the scenario which compels informatica server to reject files?

0 Answers  

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

---

Why union transformation is an active transformation?

0 Answers   Informatica,

---

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

What is the use of incremental aggregation?

2 Answers  

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---