Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)
Answer Posted / tabish khan
Frankly i dont know the answer but i told the interviewer that
we cannot do this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
flat filevalidation in informatica
list and discuss two approaches for updation of target table in Informatica and how they are different.
how do use session mapping parameters ?(in which transformation)
Which transformation we use to convert 'NA' to 'Not Available'
What is data modeling and data mining?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
What are materialized views & where do we use them?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what is granularity in Data ware House?
What do you understand by active and passive transformations?
How can we use external procedural logic in informatica?
Explain about round-robi?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what is pmrep command?
how many steps are there in etl process?