Answer / nag

Hi,

I hope this will work in SQL Transformation.

Thanks and Regards,

Nag

Answer / balanri

Expression Transformation of Informatica provides all kinds
of functions which also includes Userdefined functions. We
can also use defined variables in this.
Operators also included in this as functions.
Informatica Expression transformation provides this IN
Operator.

Answer / n.prasad

we can use In operator in source qualifier and sql
transformation if the source tables belongs oracle.otherwise
we cannot use in operator in informatica transformation.

Answer / sudha

I guess that the IN operator can used in Aggregator
transformation. Not sure if any know exact answer plz post..

Answer / sarat

IN is a n operator used to filter the records, that should participate in O/P or to be rejected.
So thats the reason, i think its Filter/Router

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

6 Answers   IBM,

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

How will you combine 3 different sources with a single source?

3 Answers  

What are the Advantages of de normalized data?

3 Answers  

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

What is the need of etl tools?

0 Answers  

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

What is difference between maplet and reusable transformation?

2 Answers  

How to display null values on a target & non-null values on a target?

3 Answers  

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,