Can we parametrize the values of IN statement.
Ex.
Inside parameter file:
Parameter='A','B','C'
Inside Code:
IN (INPUT_CHARACTER, $$Parameter)
Answer Posted / pondara shivaji
Prankly asking have u got selected interview by answering
above question.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is staging area referring to?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain etl mapping sheets?
What are snapshots?
What is virtual Data Warehousing?
Do we need an ETL tool? When do we go for the tools in the market?
what is the difference steps for data modeling?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
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
Which transformation we use to convert 'NA' to 'Not Available'
Give the benefits of data integration suite?
Explain about power designer data modeling software?
What is fact? What are the types of facts?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
dimension object created in oracle can be imported in designer?how?