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 the difference between Data Warehousing and Data Mining?
what is dynamic insert?
Explain etl mapping sheets?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is the difference between cubes and package in cognos
Explain about the data integration suite features?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
How many steps etl contains?
What is etl process. How many steps etl contains explain with example?
How to fine tune mappings?
What are the differences between sql override and update override?
what is the main role of FI on business
What is virtual Data Warehousing?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?