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
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?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Explain about hash partitioning?
how do u set partition points in the mapping?
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
Can we create Hierarchies in generic datasources?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
Explain the difference between etl tool and olap tools?
What is grain of fact?
Explain about round-robi?
how do u implement configuration management in Informatica?
How many types of transformations supported by sorted input?
What are the modules in Power Mart?
what are the types in error loging?
Do we need an ETL tool? When do we go for the tools in the market?